Fetch-on-demand iterators (was Re: [CDBI] Make CDBI go fast)
Michael G Schwern
schwern at pobox.com
Thu Feb 22 03:00:26 GMT 2007
Tim Bunce wrote:
>>> One possibility is to move executing the statement handle into the iterator
>>> so it doesn't even execute the query until you've asked for the first
>>> object. This would make it safer to hand around iterator objects.
>>> I'm using this in a mod_perl environment with no problems yet.
>> Yeah, but you're not using Sybase with mod_perl, and I am, so hence my
> I think enabling mysql_use_result would raise the same issue for MySQL,
> so it should be possible for Mr Schwern to check for problems while
I've taken this all into account and have made sure the statement handle is finished when the iterator is destroyed.
More information about the ClassDBI