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 be alot of DB hits.
It was mentioned here -> http://groups.google.com/group/cake-php/browse_thread/thread/b97c38e4c36fc781by another developer that he was forced to do his own custom queries to get around this problem. I'm considering the same solution since I gain most of my benefits of the MVC architecture from the VC and am seeing a loss for the M part of this framework. On Mon, Apr 12, 2010 at 10:43 AM, cricket <[email protected]> wrote: > On Apr 12, 12:48 pm, Adam <[email protected]> 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 simple find()/select > > that I'm doing. Are there any things that can be easily done to reduce > > the hit to the database? > > http://memcached.org/ > > > I'm planning to re-develop a high traffic site in Cake and am having > > hesitations from my initial testing. > > > > I have already set debug to Zero. I almost feel like using Cake only > > for the VC and cutting out the M (model). The database queries seem > > extremely heavy. > > You absolutely *must* set debug to 0. Without that, Cake makes a bunch > of DESCRIBE queries at minimum for each request. > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > > To unsubscribe, reply using "remove me" as the subject. > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
