• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Bottleneck in DB Tier

 
Ranch Hand
Posts: 569
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic