nate wrote: > Yes, query results are cached (somewhere in DboSource I believe). But > if you're paging results, why are you doing it by reading the entire > resultset into memory? > > Model::findAll( ) has the $limit and $page parameters so you don't have > to.
Ah, I think I may not have explained my situation clearly enough, sorry. I tried first to read the entire resultset into memory and that failed so I then started to use the $limit and $page parameters and to my surprise found myself *still* running out of memory. The code fragment I pasted in the original posting was supposed to demonstrate my use of findAll( ..., $limit, $page ) and I guess I was asking for advice as to whether the code fragment was valid (is this how findAll() is expected to be used) or not. If it is valid then something is wrong 'cos it looks to me that I'm not using great amounts of memory using this approach. Allan --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
