Re: Tips for cutting queries and load time?

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 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
-~----------~----~----~----~------~----~------~--~---