• Post Reply Bookmark Topic Watch Topic
  • New Topic

Database data retrieval in many steps?

 
jacob deiter
Ranch Hand
Posts: 585
  • 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
Sheriff
Posts: 36000
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try searching for "paging" in this forum.
 
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!