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