On May 14, 9:27 am, AD7six <[email protected]> wrote: > 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
^ That's got nothing to do with optimization. Native or otherwise. You are asking for 10563105635 rows of data - which is an E-normous amount of data. If your app is using all 10 billion rows you're asking for - why, if it's not - why are you asking for them? AD -- 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
