On Dec 29, 2010, at 13:00, arron wrote: > So i have a relationship table that has 6 tables the primary id is > indexed as well as the models that paginate is using . > > > The problem i am having with pagination is when i edit a row or add a > row the SELECT COUNT(*) query takes forever around 11956MS it also > maxes out my CPU for about 8 seconds. I only have 92K records, if i > edit a row or add a row via phpmyadmin it only takes about 7ms. any > suggestions ? Can i turn off the or get rid of the SELECT COUNT(*) > query ?
Have you asked your database server why the query is slow? Perhaps using EXPLAIN? That might point out a missing index or something. 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en