Ok I fixed the Major slow problem. It was a coding bug, where a session variable was checked and if it was not set the database would be queried to count all adviews currently over 12 million. however the session variable was never updated so this query was always called on every link click :(
Thanks for the troubleshoot support. On Fri, Apr 13, 2012 at 4:29 PM, Bruce Wade <bruce.w...@gmail.com> wrote: > Ok I want to add when I go to admin/app/database administration it is also > slow > > > On Fri, Apr 13, 2012 at 4:17 PM, Bruce Wade <bruce.w...@gmail.com> wrote: > >> psql -h connection was instant >> psql query was very fast no delay >> >> python web2py.py -S yaw -M connected without any problems and was fast. >> >> Think it maybe related to rotating banners, new feature. >> >> On Fri, Apr 13, 2012 at 12:30 PM, Michele Comitini < >> michele.comit...@gmail.com> wrote: >> >>> To debug do some tests on the web2py machine using psql with -h >>> >>> check for the time it takes to connect to the remote postgresql server >>> and the time to process a query. >>> If the connection takes a long time to setup, it is most likely some >>> dns related problem. >>> If the queries are slow to complete, then you should check the same >>> queries but from the server machine itself, if it is slow in both >>> cases it is a problem with that machine, else if it is slow just on >>> the web2py machine it is a network related problem. >>> If there is no speed issue using psql then try doing some dal queries >>> calling web2py on console with -S and -M options. If that is fast the >>> problem is related to something else in the code. >>> >>> mic >>> >>> >>> >>> >>> Il 13 aprile 2012 20:56, Bruce Wade <bruce.w...@gmail.com> ha scritto: >>> > Linode same datacenter different nodes >>> > >>> > On Apr 13, 2012 11:53 AM, "Bruno Rocha" <rochacbr...@gmail.com> wrote: >>> >> >>> >> are you connecting by internal private network or over the internet? >>> there >>> >> are firewall filtering the packages? >>> >> >>> >> On Fri, Apr 13, 2012 at 2:33 PM, Bruce Wade <bruce.w...@gmail.com> >>> wrote: >>> >>> >>> >>> Hi, >>> >>> >>> >>> When I was running the site and database on the same server there >>> were >>> >>> not speed problems. However as soon as I switched to have a dedicated >>> >>> database server page loading becomes very very slow. >>> >>> >>> >>> Any suggestions? >>> >>> >>> >>> -- >>> >>> -- >>> >>> 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 >>> >>> >>> >> >>> >> >>> >> >>> >> -- >>> >> >>> >> Bruno Rocha >>> >> [http://rochacbruno.com.br] >>> >> >>> > >>> >> >> >> >> -- >> -- >> 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 > > -- -- 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
