set the limit in the $model->find(); to an acceptable performance
level - you can set this dynamically - or look into the pagination
component
On Aug 6, 6:41 pm, jheathco <[EMAIL PROTECTED]> wrote:
> In PHP, typically prior to cake I had done
>
> $res = mysql_query();
> while($row = mysql_fetch_array($res))
> {
> ....
>
> }
>
> And now in cake, $results = Model->find([query here]) and then loop
> thru the results.
>
> I am wondering about the limitations if, for instance, a few thousand
> rows are returned. In PHP, it seems looping thru each, one at a time,
> by calling mysql_fetch_array() was very efficient. However, it seems
> like cake may have large performance (and memory) issues by trying to
> dump all results into an array before looping thru.
>
> Am I correct in this thinking? Is there a way to have cake only
> return the results one at a time, rather than buffering them all into
> a large array?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
