Friday, April 24, 2009

Tips for cutting queries and load time?

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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

No comments: