If you have a million row result set, you made a mistake. ;-) IMO, there are two good ways to do this: - Use something like iBATIS to do paginated lists - Use a stored procedure to return the page from the dataset
Larry On Apr 7, 2005 4:13 PM, Wiebe de Jong <[EMAIL PROTECTED]> wrote: > > > If you have a million-row result set, this approach won't work. You'll > need > to make a trip to the database whenever the user wants a new page. I'm > working on doing this right now. >