Re: Tips for cutting queries and load time?

Debug Kit will make your page run slower. It adds a lot of extra code
to each page view. It adds a lot of HTML and several function calls
all over the place. However, it does not at this time interfere with
database queries.

Perhaps you should look into adding indexes on your foreign keys if
you have not done so already.

-Mark

On Apr 24, 9:34 pm, "Dave Maharaj :: WidePixels.com"
<d...@widepixels.com> wrote:
> Thanks for all the advice.
>
> The ARO/ACO queries are not the factor in the time its taking so far. Mostly
> the requests for the related tables. Going thru unbinding them and that
> seems to have helped greatly.
>
> I have the toolbar installed...wondering if all the info in there is also
> adding to the time in anyway?
>
> Thanks,
>
> Dave
>
>
>
> -----Original Message-----
> From: James K [mailto:james.m.k...@gmail.com]
> Sent: April-24-09 11:00 PM
> To: CakePHP
> Subject: Re: Tips for cutting queries and load time?
>
> 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"
> <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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---