On Fri, 10 Oct 2003 18:14:00 -0700, [EMAIL PROTECTED] (Douglas Wilson) wrote:
> > >-----Original Message----- >From: ed [mailto:[EMAIL PROTECTED] > >> Hey all. Is there a way to a seek of some sort on a result set. >> Specifically I'd like to know if you can rewind the result set after >> you've looped over all the records with fetchrow_* . > >There has been some discussion on the dbi-dev list about >implementing scrollable cursors in DBI, >(http://www.mail-archive.com/[EMAIL PROTECTED]/msg01904.html) >but I don't think its been done yet. Next best thing would be to >do a selectall_* or fetchall_* and 'scroll' through that. > >-Douglas Wilson Those methods load all of the rows(meaning the data contained in the rows) into memory don't they? If so, that should be considered when working with large result sets. Thanks for the reply. --ed
