I'm using hibernate 3.2 JPA in my project and oracle db. we are facing poor response time(though only one record is fetched from the db) when there are large number of records in DB and user has to wait longer time to get the page in GUI. The issue has become very critical now.
Response time was good initially in prod when there were less number of records in db.

We use hibernate only to fetch records(there is no insert/update/delete) and i've disabled the second level cache.
Please suggest some hibernate optimization to resolve this issue.

Thanks!

optimize your database to use indexing for faster searches...