• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate is used, db response is slow

 
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?
 
rajesh bala
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic