RE: [PEAR] Trying to loop through MDB rowset -

My thinking is that it's probably not too significant unless the result set is very large. But to really know someone would have to benchmark it I guess. Just something to ponder. I'll continue to work with the current functionality. Thanks for all the work on MDB. Matt Friedman Web Applications Developer www.SpryNewMedia.com Phone: 416 992 5482 Email: matt@SpryNewMedia.com > -----Original Message----- > From: Lukas Smith [mailto:smith@dybnet.de] > Sent: Thursday November 7, 2002 2:42 PM > To: 'Matt Friedman'; pear-general@lists.php.net > Subject: RE: [PEAR] Trying to loop through MDB rowset - > > > From: Matt Friedman [mailto:matt@sprynewmedia.com] > > Sent: Thursday, November 07, 2002 8:32 PM > > To: smith@dybnet.de; pear-general@lists.php.net > > Subject: RE: [PEAR] Trying to loop through MDB rowset - > > > > Thanks very much Lucas. > > > > Is loading up a new array with the whole result set ok (as in > queryAll)? > > I had actually thought that using the Resource Id instead of filling a > > result set object/array was more efficient. The impression I have is > > that using a result id uses less memory. What about large result sets? > > This may not be a big issue - I'm just throwing it out there. But > that's > > actually why I was trying to avoid using queryAll if I could. > > > > What about the ability to _not_ free the result so that you can > continue > > to loop through using the resource id when you use fetchRow etc...? > (via > > some flag or something?) > > > > Anyway, thanks again :) > > > > well hmmm ... > I ported this behavior from DB's get+() methods. > Recently there was the addition of autofree (automatically free a result > set when the end of the result set is reached). So maybe I shoud > re-examine this. Adding another flag is probably not a good idea because > most methods in MDB have so many parameters already due to the datatype > abstraction. > > Fetching everything at once will be faster I am quite sure as you have > less function calls. Then again you might be right that is uses more > memory. > > Regards, > Lukas > > > -- > PEAR General Mailing List (http://pear.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php