in reply to Using large result sets from a database
I don't how feasible it is, but HTML::Pager might be worth exploring. I've never used it myself but it's something I have kept in the back of my mind for just this sort of problem. My questioning the feasibility is that I'n not sure how you crack the persistency problem, though, in terms of how you write the callback that is required by the HTML::Pager object to fill the page template. This hinges on the problem of keeping the database connection open (assuming you're not planning on using mod_perl, in which case it would be a snap).
|
|---|