Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to get the records from data base in chunk

 
Amit K Jain
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a SQL query which is is querying multiple tables and has group by, order by and subqueries. I have tried to tune the query as much as possible. It has proper indexing on the columns. However, it takes time to execute and causes time out in the web application. If I limit the number of records by rownum<100, it is quick. Can we get complete records in group of fix number of records and map to pojo objects. Is there any way in Hibernate to do so.

Please help.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!