I'm getting the same problem -- but instead of wanting to wait until a timeout occurs, users just want to go to another section of the app. For some reason though, when going through the app built in cake, it instead hangs until the query times out and fails or the query is killed in mysql. In a plain PHP file using the mysql functions, I can go to a different page even if a query is still running on the page.....
Is there like a cake query abort function? Thanks, Beverly On Apr 11, 6:38 am, trav <[EMAIL PROTECTED]> wrote: > what is the response time of the query on mysql console? Make sure > you have it humming (indexes etc..) here first! cake may not be your > issue. it could be you db schema. > > t. > > On Mar 17, 4:24 pm, 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 cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
