I'd look into re-evaluating how you're using ACL. If your ARO/ACO queries are taking that long you may be relying too heavily on Cake's built in (and horribly inefficient) ACL implementation.
- James On Apr 24, 10:08 am, "Dave Maharaj :: WidePixels.com" <[email protected]> wrote: > I was hoping to get some general tips on how to speed up load time and cut > down on the number of queries in a request. > > I have for example 18 queries took 123 ms for 1 page. I have been cleaning > up find queries to use contain and only query fields I need cleaning out > ones not needed, unbind models in some actions to remove tables not needing > to get data from on others and in some cases cacheQueries. > > In my 18 queries took 123 ms example there are no "describe" tables...just > the ARO/ACO and general queries to grab info for the page. I have not made > any custom JOINS or anything anywhere in the site, only the ones cake makes > with its relationship tables. > > Can someone provide info on how to speed things up beyond what I have been > doing? > > thanks > > Dave --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
