I have a simple database set-up and have optimized the query using cakephp's containable behavior to where I get only the fields I need (I check this with a debug command to see the array). However when I set the debug level to 2 in core.php, I notice many repeat SQL calls on foreign keys.
For example: 115 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 50 116 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 47 117 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 49 118 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 47 119 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 120 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 121 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 122 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 123 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 124 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 125 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 126 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 127 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 128 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 129 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 130 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 131 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 132 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 14 133 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 21 134 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 21 135 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 21 136 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 21 137 SELECT `Manufacturer`.`name` FROM `manufacturers` AS `Manufacturer` WHERE `Manufacturer`.`id` = 21 Where manufacturers is a table two levels removed from the main table. It seems that cake should be able to cache and reuse the result for the same `Manufacturer`.`id`. Is there a way to achieve this? Does this only happen at debug level 2 perhaps and not level 1? (And how to I find out what sql queries are going on at levels 0 & 1?) thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
