[TYPO3-dev] DB query iterator; worth a try?

Ries van Twisk typo3 at rvt.dds.nl
Fri Apr 23 13:45:14 CEST 2010


On Apr 23, 2010, at 2:13 AM, Jigal van Hemert wrote:

> Martin Kutschker wrote:
>> You can already use exec_SELECTgetRows() if foreach() is all you  
>> need.
>
> ... which loads the entire result set in an array. TYPO3 is already  
> eating a lot of memory as it is.
> The nice thing about an iterator is that it still only loads one  
> record at a time.
> You don't need to do the call to the fetch-method yourself, because  
> that is handled also by the iterator.
>

In reality it really doesn't matter because the recordset is loaded  
into memory anyways.

Ries




More information about the TYPO3-dev mailing list