Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate. database response is slow even for single record query

 
Divya Rajendra
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you profiled the code to see if the slowness is within code, Hibernate, or in the database itself?

Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic