On Fri, Dec 24, 2010 at 2:18 PM, huoxito <[email protected]> wrote: > I am trying to make cake not generate the kinds of queries below every > minute or so. Reading the book I found the controller attribute > persistModel. I set it true in one of my controllers but these show full > columns queries still shows up every minute. > > 1SHOW FULL COLUMNS FROM `drg_aros` > 771 2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE > COLLATION_NAME= 'utf8_general_ci'; > 110 3SHOW FULL COLUMNS FROM `drg_acos` > 771 4SHOW FULL COLUMNS FROM `drg_aros_acos` > 771 5SHOW FULL COLUMNS FROM `drg_usuarios` > 12121 6SHOW FULL COLUMNS FROM `drg_sugestos` > 660 >
That information shows up because you have debug > 0. Cake will not run them in production mode. Always set debug to 0 before evaluating Cake's performance. > Could anyone please explain if the persistModel attribute really make any > improvements on performance and how? I found it strange that the book barely > gives any info on it. > It causes Cake to cache the model. I'm not the person to give an in-depth explanation, though. Sorry. > And how do you set up your apps on cakephp to be as fast as possible? > > Search for "cakephp performance tuning"; there are a lot of articles which contain useful tips. Keep in mind, though, that a website's performance is due to a number of different factors. Make sure Apache and your DB are properly configured. Things like removing htaccess support, normlisation, indexes, etc. can make a big difference. Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" 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
