#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

 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 
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 
For more options, visit this group at 

Reply via email to