why not to increase the amount of "die time" with set_time_out(), at least to read the sql querys.
Cheers, mbavio On Apr 7, 3:55 pm, "b logica" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
