This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes Performance and the fly likes Hibernate is used, db response is slow Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "Hibernate is used, db response is slow" Watch "Hibernate is used, db response is slow" New topic
Author

Hibernate is used, db response is slow

Divya Rajendra
Greenhorn

Joined: Mar 25, 2008
Posts: 2
When I am using large database, even a single record query takes a long time to be retrieved from the database.

Example: Select user from user where id=10 . Here id is a primary key.

I have done indexing based on the queries I need, even these queries are getting slow as the size of the database and table grows.

Have anyone faced similar problem? Can anyone help me on this issue?
rajesh bala
Ranch Hand

Joined: Jan 14, 2003
Posts: 66
It would be clear, if you can say

1. Is the query running slow when directly hit against database with sqlplus or so? Or Is it slow only running through hibernate?


If its slow when running from sqlplus, you can give the "execution plan". Did you analyze the DB statistics?.

~Rajesh.B
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate is used, db response is slow
 
Similar Threads
Hibernate. database response is slow even for single record query
Better way of doing this?
Improving response time
Running multiple queries concurrently
why db is taking so long time to respond ?