Thanks for explaining. Looks like something I will need to spend some
time with soon :)
On Apr 24, 7:01 pm, brian wrote:
> On Fri, Apr 24, 2009 at 11:10 AM, Martin Westin
>
> wrote:
>
> > Views, I haven't got my head into yet but it sounds like I probably
> > should :)
>
> Views can make a big
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 inef
If I remember correctly, the ARO/ACO tables are not indexed by default
(this may have changed in later versions of cake).
On Apr 25, 10:08 pm, Miles J wrote:
> Make sure you have indexes set on your database.
--~--~-~--~~~---~--~~
You received this message because
Make sure you have indexes set on your database.
--~--~-~--~~~---~--~~
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 ema
On Sat, Apr 25, 2009 at 4:37 AM, Faza wrote:
>
> You set-up a view in your database, and then add the model as for any
> other table in CakePHP.
I guess that makes sense. ill give that a go.
> Dunno about other DB's, but since few releases PostgreSQL allows
> INSERT/UPDATE of views. Pretty neat
You set-up a view in your database, and then add the model as for any
other table in CakePHP.
Dunno about other DB's, but since few releases PostgreSQL allows
INSERT/UPDATE of views. Pretty neat feature, because - if keyed
correctly - you can make all relations DB-side.
brian pisze:
> On Fri,
On Fri, Apr 24, 2009 at 9:21 PM, James K wrote:
>
> You can modelize views just like you can tables. No need for query()
>
Care to give a hint?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To po
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 tha
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"
wrote:
> I was hoping to get some general
You can modelize views just like you can tables. No need for query()
- James
On Apr 24, 1:01 pm, brian wrote:
> On Fri, Apr 24, 2009 at 11:10 AM, Martin Westin
>
> wrote:
>
> > Views, I haven't got my head into yet but it sounds like I probably
> > should :)
>
> Views can make a big difference
On Fri, Apr 24, 2009 at 11:10 AM, Martin Westin
wrote:
>
> Views, I haven't got my head into yet but it sounds like I probably
> should :)
Views can make a big difference. Well worth looking into.
Unfortunately, they require using query(). I thought I saw something
about being able to query view
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
On 04/24/2009 05:08 PM, Dave Maharaj :: WidePixels.com wrote:
>
> Can someone provide info on how to speed things up beyond what I have been
> doing?
>
I don't know what you have been doing but here's Matt's '8 Way for speed'
http://www.pseudocoder.com/archives/2009/03/17/8-ways-to-speed-up-ca
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 numb
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 model
15 matches
Mail list logo
