#6281: SELECT COUNT(*) ... GROUP BY causes memory spike with mysqli ------------------------+--------------------------------------------------- Reporter: sdewald | Owner: Type: Bug | Status: closed Priority: Medium | Milestone: 1.2.x.x Component: MySQLi | Version: 1.2 Final Severity: Normal | Resolution: invalid Keywords: | Php_version: n/a Cake_version: | ------------------------+--------------------------------------------------- Comment (by sdewald):
Wow... you're right. I am a complete idiot. Just ran the query in MySQL and saw 1 million rows returned. So I guess my confusion was that I expected to run find('count', ...) with the same parameters I run find('all', ...) on and get the number of rows, but that just isn't the case with a GROUP BY statement. I'll have to read a little bit more about doing pagination with GROUP BY. Thanks for your help. P.S. Love your blog too. Keep up the good work. -- Ticket URL: <https://trac.cakephp.org/ticket/6281#comment:5> CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/> Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "tickets cakephp" group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to tickets-cakephp+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~----------~----~----~----~------~----~------~--~---