#6245: HABTM primaryKey identified in one direction only, bad DELETE queries
---------------------------------+------------------------------------------
    Reporter:  cuppett           |         Owner:           
        Type:  Test Case         |        Status:  reopened 
    Priority:  High              |     Milestone:  1.2.x.x  
   Component:  General           |       Version:  1.2 Final
    Severity:  Major             |    Resolution:           
    Keywords:  HABTM primaryKey  |   Php_version:  PHP 5    
Cake_version:  1.2.2.8120        |  
---------------------------------+------------------------------------------
Comment (by cuppett):

 Also, not sure why MySQL includes WHERE clauses for both columns; however,
 with large HABTM tables a huge IN() part might have a negative impact on
 performance.  The query PostgreSQL is generating seems to be superior with
 the single value WHERE clause on the appropriate side to delete the whole
 set.

-- 
Ticket URL: <https://trac.cakephp.org/ticket/6245#comment:11>
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