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 caching, make it query against db in 1 hour ...
it a lot of optimization in my apps... cause user need the same data anyway..and 500 user query the same data in 1 minute is a lot of resource.. but with cahce, you retreive it once from db, use it all the time, and update it in the time set up for it.. On Tue, Apr 13, 2010 at 2:07 AM, altermod <[email protected]> wrote: > 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 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 > 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 To unsubscribe, reply using "remove me" as the subject.
