OK so here is a little bit before and after I still have a lot of work to
do:
Before:
============================================================
/
============================================================
Sat May 12 15:39:07 2012 profiler.log.tmp
85845 function calls (84497 primitive calls) in 0.128 seconds
Ordered by: internal time
List reduced from 743 to 80 due to restriction <80>
After:
============================================================
/
============================================================
Tue May 22 16:14:27 2012 profile.log.tmp
52095 function calls (50779 primitive calls) in 0.085 seconds
Ordered by: internal time
List reduced from 727 to 80 due to restriction <80>
On Mon, May 14, 2012 at 12:06 PM, Bruce Wade <bruce.w...@gmail.com> wrote:
> Yes, I have started moving everything from models to custom api modules
> this weekend.
>
> I am going to try to use most of the tips provided by everyone.
>
> For the adviewer I will look to see what is calling 10 query's. However I
> can not cache this query as the returned ads most be random for every user.
> Also I load 5 ads at first so besides rating the ad there should only be
> one major query ever 5 * 20 (seconds).
>
> I will have a lot of these changes done by Weds and will provide a new
> profile report.
>
> --
> Thanks
>
> On Mon, May 14, 2012 at 11:07 AM, Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> If one has more than 10 tables, one should use conditional models and one
>> should move all state dependent settings into the controllers that need
>> them,
>>
>> Massimo
>>
>>
>> On Monday, 14 May 2012 11:36:00 UTC-5, pbreit wrote:
>>>
>>> Aren't 135 table definitions going to be a problem in a high volume app?
>>> Aren't many/most of those 85k-100k function calls going to
>>> examining/parsing all those tabledefs?
>>
>>
>
>
> --
> --
> Regards,
> Bruce Wade
> http://ca.linkedin.com/in/brucelwade
> http://www.wadecybertech.com
> http://www.fittraineronline.com - Fitness Personal Trainers Online
> http://www.warplydesigned.com
>
>
--
--
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.fittraineronline.com - Fitness Personal Trainers Online
http://www.warplydesigned.com
