[fw-db] Parsing through large result sets

Oi

Now I have googled through various search queries for the last two hours and I'm about to toss the towel.

I am used to do something like this:

$sql = "SELECT something FROM random-table-with-an-obscene-large-amount-of-entries"; $res = mssql_query($sql); while ($row = mssql_fetch_array($res)) {   // do some with the data returned in $row }

Now I have moved over to Zend_Db and want to do the very same thing, but how?
Some places I use a simple straight through approach like:

$sql = "SELECT something FROM random-table-with-a-small-amount-of-data"; $rows = $db->fetchAll($sql); foreach ($rows AS $row) {   // do some with the data returned in $row }

However I run into memory problems, if I use that approach with my random-table-with-an-obscene-large-amount-of-entries.

What am I missing here? Isn't it possible to use a while()-structure to loop through a Zend_Db result set? Thanks in advance...

---

View this message in context: Parsing through large result sets
Sent from the Zend DB mailing list archive at Nabble.com.