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] >> >
