• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Bottleneck in DB Tier

 
Alec Lee
Ranch Hand
Posts: 569
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am connecting Tomcat to Oracle thru thin JDBC driver. The link between tomcat & oracle is now found to be the bottleneck - too many JDBC calls that could be handled by the network. What are the possible solutions I can use now?

Some suggest to use Oracle Real Application Cluster (RAC) to scale the db tier. I am new to this. Would setting up RAC causes any change to my programs? Is it difficult to setup? Also, are there any other alternatives?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Alec Lee:
What are the possible solutions I can use now?

- Batch JDBC calls to reduce number of queries.
- Make sure you aren't returning any unneeded fields in the result set
- Scale up (as you suggested)
- Add more hardware
- Any combination of these.


Would setting up RAC causes any change to my programs? Is it difficult to setup?

No RAC will not change your programs. The difficulty would depend on your familiarity with Oracle administration.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Note that RAC won't help if the bottleneck is the network. It would help if the bottleneck is the database.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could also consider an ORM tool with some caching and cache synchronisation. For example Toplink will assist here. It is still easier in general to upgrade the database server though.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic