Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database data retrieval in many steps?

 
jacob deiter
Ranch Hand
Posts: 584
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I want to retrieve result set from database, If the result set is huge then I want to retrieve some part of total result set and retrieve the remaining in next sequence of retrievals.

My question here is

In my first database hit ,I retrieve the first set of the result,
In the second database hit, How it can refer the same result?? And retrieve the remaining part ?
 
Nickolas Case
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think ResultSet fetchSize would be a good place to start.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34671
367
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try searching for "paging" in this forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic