Well, if you have your DEBUG set to 2 you can see the SQL generated, and the amount of time each query takes to execute. It wouldn't be difficult to test the performance critical parts of your app using custom SQL - but I doubt just replacing SQL will be much difference.
And don't forget the $recursive parameter for your model, and that with a value of -1 no additional JOINs are performed. On Nov 18, 9:18 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: The part I'm intrested is taht are those autogenerated joins > optimal to use in live environment or is it wiser to use specific > querys and do not get a good/easy use of autogeneration and overall > database layer. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
