On May 14, 6:23 am, OldWest <[email protected]> wrote: > 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..
Is your pentium III in a beige box? Beige computers are slower than black ones IME. But seriously - how would you expect a computer which is an order of magnitude slower than the other to respond in the same time? > > It terms of the "timer waterfall". Are you referring to the "Took MS" column > to see which query is "hogging" the resources? no. Let's put your question in perspective. You go for a 90 minute drive to <pick a place> and wonder if you can make the journey faster. So you spend 2 days analyzing the time it takes for you and your passengers to get into the car - which represents about 0.5% of your overall journey time. Even if you get it to 0 it's still going to take you 90 minutes to complete your journey. > > 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 So. you don't know what debug kit is - it'll help you to install it, or run xdebug profiles - it's pretty pointless guessing why your app is slow (3s is very slow in the first place...) without looking at real numbers - and right now I think you're fruitlessly focussing on the db log because it's the only thing you've seen with times in it. See liks below AD https://github.com/cakephp/debug_kit http://blog.japanesetesting.com/wp-content/uploads/2009/11/debug_timer.jpg (randomly googled) -- 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
