Re: findAll() memory exhaustion

2006-09-22 Thread Cheeze
Ah! That's new! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For mo

Re: findAll() memory exhaustion

2006-09-22 Thread Cheeze
Ah! That's new! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For mo

Re: findAll() memory exhaustion

2006-09-20 Thread nate
One thing I missed completely the first time around: if you set $recursive to null, it just uses the default level of recursion, which is 1. To disable pulling of associated model data, set $recursive to 0. To disable all associations, incuding LEFT JOINs, set $recursive to -1. --~--~-

Re: findAll() memory exhaustion

2006-09-20 Thread [EMAIL PROTECTED]
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 explai

Re: findAll() memory exhaustion

2006-09-20 Thread nate
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. --~--~-~--~~~---~--~~ Yo

Re: findAll() memory exhaustion

2006-09-20 Thread [EMAIL PROTECTED]
nate wrote: > Hey Alan, why you'd ever want to pull 7500 records at once in the > normal operation of an app is quite beyond me, but I know for certain > things, I have pulled somewhere around 10,000 records at once with no > issues. i have found a way round this, using a direct SQL query() but

Re: findAll() memory exhaustion

2006-09-20 Thread nate
Hey Alan, why you'd ever want to pull 7500 records at once in the normal operation of an app is quite beyond me, but I know for certain things, I have pulled somewhere around 10,000 records at once with no issues. You might want to check your memory settings in php.ini. I think the default is on

findAll() memory exhaustion

2006-09-20 Thread [EMAIL PROTECTED]
Hi, I am using findAll() to retrieve about 7500 records. My current PHP setup is such that this fails with an out of memory error. So I tried this: $conditions = null; $fields = null; $order = null; $page = 0; $limit = 200; $recursive = null; while( 1 ) { echo