If you're having problems with pagination turned on, chances are the issue is in your database server, rather than cake. Cake applies pagination with a limit on the SQL, which different databases will optimised in different ways (some will require an entire resultset before limiting, mysql for example will stop looking as soon as it has enough rows). Of course the problem could also be with the count statement that cake runs before the main query when using pagination, but it's still unlikely to be a php issue.
Are you using a lot of conditions on the pagination? Are your sort fields indexed? I would recommend looking at the queries which are generated, and adding appropriate indexes to your database. Simon http://www.simonellistonball.com/ On Apr 6, 9:10 pm, crazyDavid <[EMAIL PROTECTED]> wrote: > sry about the version. it is 1.2 > > i am using only one model and i finally am able to run the script > without halt with findAll() but i need pagination as well.. the > problem persists with paginate(). > > i still can't understand. i followed the exact procedure for > pagination in 1.2 but the problem ain't fixed. > > thank you for ur suggestions guyz! > > On Mar 18, 2:29 am, "Jon Bennett" <[EMAIL PROTECTED]> wrote: > > > > are your models correct? the query that is built makes sense and all? > > > also check you're not trying to retrieve records from too many tables > > (via associations) at once, this could time-out at php level if you've > > not got a great amount of ram. > > > jb > > > -- > > > jon bennett > > w:http://www.jben.net/ > > iChat (AIM): jbendotnet Skype: jon-bennett --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
