Sorry, no. I should've clarified that. Luckily for me, the client decided she wants the whole shebang on one page. I'm not sure she yet realises that some queries are bound to produce a honking bunch of results :-p
I'd *really* like to figure out how to paginate this, all the same. There are tricks to get around Cake's pagination shortcomings but they don't seem to apply to the several instances where it's not working for me ;-( On Mon, Apr 7, 2008 at 2:40 PM, crazyDavid <[EMAIL PROTECTED]> wrote: > > are you also using pagination along with Model:query() ??? > > On Apr 7, 11:30 pm, "b logica" <[EMAIL PROTECTED]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
