Re: [web2py] Database connections speed issue
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]
Re: [web2py] Database connections speed issue
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]
Re: [web2py] Database connections speed issue
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]
Re: [web2py] Database connections speed issue
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
Re: [web2py] Database connections speed issue
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
Re: [web2py] Database connections speed issue
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