File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Hibernate is used, db response is slow
Joined: Mar 25, 2008
Mar 25, 2008 22:49:00
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?
Joined: Jan 14, 2003
Mar 26, 2008 03:56:00
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?.
I agree. Here's the link:
subject: Hibernate is used, db response is slow
why db is taking so long time to respond ?
Hibernate. database response is slow even for single record query
Better way of doing this?
Improving response time
Running multiple queries concurrently
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015