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
