http://www.perlmonks.org?node_id=916597


in reply to Re: Tie'ing a dbh result set?
in thread Tie'ing a dbh result set?

Actually, it isn't that difficult to implement. Ultimately, I will be using a 'sliding window' for each result set to retrieve all the data transparently. As I really don't care about what I've already retrieved, I can pull back say 5,000 rows, on the request for 5001st row, purge the first 5000 rows and pull back another 5,000 from the database. The only thing I have to worry about is to to make sure the FETCH() and FETCHSIZE() handle the window.

Jason L. Froebe

Blog, Tech Blog