On Oct 6, 11:36 pm, wmshay06 <[EMAIL PROTECTED]> wrote:
> We have a customer using what was supposed to be a production system
> based upon cakephp 1.1.18 - which really isn't. That aside there are
> very signficiant issues that need urgent resolution, whcih we just
> can't find a way to solve readily.
>
> 1. the number of db queries is absolutley astounding - example
> constructing a left hand submenu and overview display of roughly 20-25
> table rows of data leads (with about 10 elements in each row) to
> roughly 49000+ queries.
I don't think I could generate that many queries even if I tried.
The obvious and logical answer is to look at, and optimize the call
to, each find in your code one by one. You should find that even after
a few minutes of 'optimizing' you have reduced that by and order of
magnitude if not 2.
I also agree with Joe's comments regarding coding style.
AD
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
