I use database views, at least for the view pages, if possible. It's faster to perform joins db-side, and then return just a simple view to CakePHP.
My 0.02USD Dave Maharaj :: WidePixels.com pisze: > 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 -~----------~----~----~----~------~----~------~--~---
