I'm going to try this method of pagination retrieve from the FAQs. I have never had the necessity of using anything less than the entire ResultSet. How do I skip rows? Is it done with the ResultSet object? If not, I can do this in a loop by counting to the row I want to begin on. I just thought there might be a way to jump to the row I want. Is there?
Repeat the query for each new request.
Algorithm
Client requests page 1
Execute the query
Return rows for page 1
Client requests page 2
Execute the query
Skip rows for page 1
Return rows for page 2
Repeat the query for each new request.
Algorithm
Client requests page 1
Execute the query
Return rows for page 1
Client requests page 2
Execute the query
Skip rows for page 1
Return rows for page 2