Caching, and lots of it, and DB clustering/replication are definitely the quickest fixes.
One minor point is to avoid using Cake's multi join SQL, which (I believe) can literally add thousands of queries when a single one would do. In such cases, don't be afraid to use query() instead of findAll - although examining your DB for low performance or often repeated queries is great for deciding if the benefits are relly worth the effort. And remember, hardware is less expensive than development time, so don't sacrifice code maintainability and clarity for tiny performance increases, as you'll pay a lot more in the long run. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
