Storing Recordset to Session Variable?
Posted on 2001-07-18
Should I attempt to do this? I have a query which produces thousands of records and i would like to span over a couple of pages. I know you all have seen it, a page which says "Page 1 of 5" and has next and previous buttons. I need to do something like this. So should I store the recordset to a session variable to use it among the pages or will there be a performance issue? should i store the recordset to an array, store the array to a session variable, and destroy the recordset? would that be quicker? i need some clean code that runs FAST. thanks guys.