I've just put together an app that starts with 600k records and will be growing quickly. I chose to go with standard queries rather than use any of Cake's methods. I wanted to use Cake's pagination but was running into a similar problem as yourself (the script would run out of RAM, even when bumped up to 128MB just to debug). Because PHP was crapping out, I couldn't learn exactly what SQL Cake was trying to use. I posted a question here but didn't hear anything back. So, I'm just using Model::query() which works just fine.
On Mon, Mar 17, 2008 at 2:24 AM, crazyDavid <[EMAIL PROTECTED]> wrote: > > I'm developing an application in cakephp 2.0 which needs to handle > database with minimum of 100,000 rows of data. I'm using mysql > database and apache (xampp). I'm facing a lot of problems during > findAll() and paginate(), the script halts and is not executed > completely. has someone been through a similar problem or someone > knows the way around it, i'd be greatful to your suggestion and help. > thanks in advance. > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
