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
