Being forced into using Cake I'm trying to find out how to avoid
getting a custom query result returned as a complete array set at once
(seems to be the case with query()) - which will not scale for large
datasets where the array and all the internal loops are too heavy in
both memory and cpu usage.
I have tried skimming through some of the Cake framework code and can
see that something like rawQuery and fetchRow looks more like what I
want. Something along this
$db = ConnectionManager::getDataSource($this->useDbConfig);
$res = $db->rawQuery($sql);
while ($row = $db->fetchRow()) {
...
}
But... When I then do other cake queries inside the while outer loop,
then the $db result set gets overridden, so it's not the right way.
So the question is - how do I do an effective outer result loop while
still doing inner loop queries not overriding outer loop?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
