• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Bottleneck in DB Tier

 
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?
 
author & internet detective
Posts: 40200
816
Eclipse IDE VI Editor Java
  • 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
Posts: 40200
816
Eclipse IDE VI Editor Java
  • 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.
 
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.
 
Listen. That's my theme music. That's how I know I'm a super hero. That, and this tiny ad told me:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic