Hi Fasthold, Fasthold wrote: > I only need the 7th 'SELECT' statement, but the other queries take much > more loads of the server. I have tried the 'unbindModel()' method, but > it seems useless.
If you are in debug mode queries are not cached for very long (a few minute(s) I think) hence you will see DESC statements in your debug window. If you refresh the page imediately you won´t see the DESC statements, as it´s taken from the cache. if you are not running in debug mode these desc statements are cached much longer (weeks). > Is there any possible to cut these 'DESC' queries or prolong the cache > period for performance purpose. If you are debugging, you probably don´t want that - which is possibly why cake caches the DESC for a short period of time. If you are not debugging it´s not relavent, but you won´t see that because there isn´t a sql debug window :) But anyway: you can make your models persistent, which then means that there are no DESC statements: http://groups.google.com/group/cake-php/browse_frm/thread/d0e5e9cc7353ece/023dd55fddc5c3c4?lnk=gst&q=persistent+desc&rnum=1#023dd55fddc5c3c4 Cheers, AD7six --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
