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 ? 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
