Just to add my 0.01 (~$0.02 these days). If you're using mysql, I find the following additions to my.conf invaluable:
log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 2 log-queries-not-using-indexes Also, don't forget, the sql optimizer will change it's path as your data grows - just because it's not using an index on your dev data does not mean it will not on your prod data. In other words, make sure your volume test data reflects the distribution and cardinality of records in your prod data. ~GreyCells On Jul 11, 8:35 am, Marcus <[EMAIL PROTECTED]> wrote: > On 11 Jul., 00:49, Langdon Stevenson <[EMAIL PROTECTED]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
