We have an application running under apache2 with 51 tables in postgres and runs very well on apache, when put to run with the postgres nginx a request timeout error appears and locks the web-server. What might be happening? which the configuration to run web2py + postgresql + nginx?
Ovidio Marinho Falcao Neto Web Developer ovidio...@gmail.com ovidiomari...@itjp.net.br ITJP - itjp.net.br 83 8826 9088 - Oi 83 9334 0266 - Claro Brasil 2012/5/22 Bruce Wade <bruce.w...@gmail.com>: > 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 >
