On Nov 2, 12:09 am, Chris Cinelli <[email protected]> wrote: > To clarify: > -The login now work fine. Before it was taking 10-15 seconds to load. > -The outsourcing team was using "find" on the user with recursive = 2 to > retrieve some information to store in the session. That query was > generating hundreds of queries. Not anymore.
Bejeezus, they used keyboards too - everybody throw away your keyboards! They generate 100s of queries if MISused! > - Currently the page that is loaded just after the login (we are using Auth > now) has some information that related with other users. To render it, we > need a query that require 10+ joins. I get the feeling your app is using 1 tmp-table query with n joins instead of 2-n indexable-and-indexed queries just to reduce the number of queries to the minimum. That's not a good idea if true. In any case there is _no_ select statement you can't generate using find, there are times you might choose not to, but I think you/yourapp/ your team bailed early. I'll demonstrate if you show some of your sql. AD -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
