AD, I've probably overlooked a lot of things in my scramble to resolve this. I checked the specs on the new server which is running a Pentium III w/ 1 GB RAM. My dev server is running a dual core 3GB RAM ... So that's my first true realization. CakePHP seems to rely on the RAM and processor..
It terms of the "timer waterfall". Are you referring to the "Took MS" column to see which query is "hogging" the resources? I am using the join option as part of the Cake find() .. and the join does not seem to be natively optimized: SELECT `Zip`.`id`, `Zip`.`title`, `PlansZip`.`id`, `PlansZip`.`plan_id`, `PlansZip`.`zip_id` FROM `zips` AS `Zip` JOIN `plans_zips` AS `PlansZip` ON (`PlansZip`.`plan_id` IN (253, 774, 137, 505, 114, 260, 501, 841, 268, 239, 497, 762, 768, 246, 123, 750, 756, 130, 886, 836, 839, 315, 331, 299) AND `PlansZip`.`zip_id` = `Zip`.`id`) ORDER BY `Zip`.`title` ASC NUM ROWS: 10563105635 -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
