Nice list Marcus, thanks for posting it. I haven't looked at Memcache myself and persistent models, so I will be doing that next.
MySQL indexes are probably another likely target for my application. I am sure that I can improve them. Regards, Langdon >> My approach: make it work, then make it fast. > > Right! > > You can get an impressive performance gain for your CakePHP > application with: > > - setting DEBUG to 0 > - activating persistent models in your AppController (especially when > you have lots of models with many associations) > - using CakePHP's Cache class for model data (Memcache!) > - using view caching > > When your application hit your machine's limits, you should: > > - look for needless queries (use the Model->expects() method -- it > saves you a lot of database load! (http://bakery.cakephp.org/articles/ > view/an-improvement-to-unbindmodel-on-model-side)) > - look at every query against the database an check if it's using the > right indexes etc. MySQL has a lot of possibilities to speed up > queries (with a factor of 10 to 10000 or even more) > - look for needless use of $this->log() in your code - it can have an > impact to the performance of your app > - other optimizations, e. g. denormalization of data > > If you still reach the limits of your machine: Congratulations, you've > built a very successful web app! Now it's time for scaling up ... > > Marcus > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
