Re: [web2py] Database connections speed issue

2012-04-13 Thread Bruce Wade
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 :( Tha

Re: [web2py] Database connections speed issue

2012-04-13 Thread Bruce Wade
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 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 r

Re: [web2py] Database connections speed issue

2012-04-13 Thread Bruce Wade
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

Re: [web2py] Database connections speed issue

2012-04-13 Thread Michele Comitini
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, the

Re: [web2py] Database connections speed issue

2012-04-13 Thread Bruce Wade
Linode same datacenter different nodes On Apr 13, 2012 11:53 AM, "Bruno Rocha" 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 wrote: > >> Hi, >> >> When I was running the s

Re: [web2py] Database connections speed issue

2012-04-13 Thread Bruno Rocha
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 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

[web2py] Database connections speed issue

2012-04-13 Thread Bruce Wade
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.wadec