I'm implementing a page that will potentially display tens of thousands of records, therefore I need to implement paging. In order to optimize performance, I want to only fetch those records in a particular page. Fetching data takes more time than just moving the cursor. Furthermore I need to know the total number of records selected, and so far the only accurate way of determining the number is to traverse thru the entire result set and incrementing a counter (this is what I found out from other forums). Therefore it is crucial that I am able to run thru the result set at very high speed. The problem is, with the methods provided, I cannot move the cursor with fetching data. So my question is how to move the cursor without fetching.

I also have a secondary question. Is there a way to point straight to a particular record? Say I want to move to the 674th record. I heard of this AbsolutePosition method, but can't find in DBI.

Regards,
Alfred