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