You could consider setting the recursive variable of models and controllers that you don't need them to retrieve their full out associations. The associations can take up most of the time. What is taking up most of your time is not the actual requestaction itself, but all the SQL queries. Turn DEBUG 2 and see the number of SQL queries. You can see which ones you can cut.
Unfortunately your database is very large and complex. So, your best bet is to look at places where you can optimize what you are retrieving from the database at the time. For example, my order table has two associations which those associations have other associations. So, if I recursive to level 3 I would get the favorites, items (actual order), photos (the picture they ordered), album (the album the photo belongs to). But most of the time I don't need all that extra. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
