Views, I haven't got my head into yet but it sounds like I probably should :)
That is a lot of time for so few queries IMHO. Possibly one or a few are taking very long because they return many rows. Whenever I return more than 20 rows of anything I usually just want to count them or somehow pull stats from them. /Martin On Apr 24, 4:08 pm, "Dave Maharaj :: WidePixels.com" <d...@widepixels.com> 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
