Does TT will provide better TPS for my application?
914264Nov 19 2012 — edited Nov 20 2012Hi all, we have built a java application with oracle database backend.
After deploying the application to the product line, we find it has a poor TPS because of oracle database.
The bottleneck is the poor performance of IO of the database server but we have no more cost on purchasing better hardware.
After google a lot,TT seems to be a potential solution for our poor TPS.
Updatable cache loading data into memory from oracle can be persistent to oracle async and automatically.
This is a really cool stuff!
But here comes my questions about applying TT to my application,I need the minimum modification.
So the simplest approach is to change the underlying datasource to be TT datasource.
Our business logic is written with oracle storing process in which use sequence to create ID for new record.
I donot know if TT will pass through statments such as sequence and storing process to oracle or not?
If not do I need create oracle storing process or sequence in TT again and TT can keep synchronization just like other tables?
Sorry for so many question from TT newbie.
Regards & Thanks