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

Jigal van Hemert jigal at xs4all.nl
Fri Apr 23 09:13:47 CEST 2010


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.

-- 
Jigal van Hemert
skype:jigal.van.hemert
msn: jigal at xs4all.nl
http://twitter.com/jigalvh




More information about the TYPO3-dev mailing list