you can optimize your cake so it not always query to sql everytime user
access the same data.
you can do it with memcache, cake cache component with time caching method,
so if your data is not always changing, like in 1 hour you got 1 update, you
can cache it in your memcache, and in the app cachin
I think I just need to turn off transactions since I'm using Postgresql. I
get 2 transaction queries Begin / Rollback on pages where I make no db
queries. This is definitely not necessary.
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questi
I think the bigger issue is 2 devs on protgres reporting the extra
queries with debug zero. For simple selects
On 4/12/10, Zaky Katalan-Ezra wrote:
> With 200K hits you should do a lot of performance work no matter which
> framework you use.
> Do what ever you can in the database, use stored pr
With 200K hits you should do a lot of performance work no matter which
framework you use.
Do what ever you can in the database, use stored procedure to enjoy
execution plan caching and less transactions.
Do what ever you can in the client side.
Sophisticated work flow UI can also reduce execution t
I did set debug to Zero but it is still doing too many extra queries even
when I unbind/contain associations. I just want 1 simple select to execute
when I login. I see the extra queries and it adds about 25ms on the db which
for a high traffic site multiplied over all the other queries is going to
On Apr 12, 12:48 pm, Adam wrote:
> I've been developing cake with Postgres db and I see that the postgres
> logs are getting hit alot with lots of queries from a simple db
> select. I try using contain to limit associations but it seems that
> Cake is doing alot of other things other than the simp
I've been developing cake with Postgres db and I see that the postgres
logs are getting hit alot with lots of queries from a simple db
select. I try using contain to limit associations but it seems that
Cake is doing alot of other things other than the simple find()/select
that I'm doing. Are there