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 [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 -~----------~----~----~----~------~----~------~--~---
