#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
-~----------~----~----~----~------~----~------~--~---

Reply via email to