Thread: Web server to Database Taking forever
Sometimes when you click on a link on my site to access my postgres database it takes forever for it to connect. You can click this link and see how long it takes.
http://www.3idiots.com:8080/example.../wantedlist.jsp
It doesn't do it all the time. Sometimes its really fast. I can't figure out what is wrong. If I go on the server where the database is I can connect and run queries with no problem. I can also access the database from Access and run queries with no problems. It is only a problem when you come from the web. Tomcat and apache are both working. You can see this by going here
http://www.3idiots.com:8080/example...moviesearch.jsp
I am using
psql (PostgreSQL) 7.2.1
tomcat 4.0.1
apache-1.3.9-4
Redhat linux 6.2
Does anyone know what I can check to see what is causing this. It seemed to have happened all of sudden one day. I don't know what could have changed to cause this. I have rebooted the server and it still happens. Any help will be greatly appreciated.
Also I need to add that I never get an error message. It just sits there for quite some time. Eventually it will work.
http://www.3idiots.com:8080/example.../wantedlist.jsp
It doesn't do it all the time. Sometimes its really fast. I can't figure out what is wrong. If I go on the server where the database is I can connect and run queries with no problem. I can also access the database from Access and run queries with no problems. It is only a problem when you come from the web. Tomcat and apache are both working. You can see this by going here
http://www.3idiots.com:8080/example...moviesearch.jsp
I am using
psql (PostgreSQL) 7.2.1
tomcat 4.0.1
apache-1.3.9-4
Redhat linux 6.2
Does anyone know what I can check to see what is causing this. It seemed to have happened all of sudden one day. I don't know what could have changed to cause this. I have rebooted the server and it still happens. Any help will be greatly appreciated.
Also I need to add that I never get an error message. It just sits there for quite some time. Eventually it will work.
Scott
Scott Dunn
The Software House, Inc.
513.563.7780
Scott, > Sometimes when you click on a link on my site to access my postgres > database it takes forever for it to connect. You can click this link and > see how long it takes. > <http://www.3idiots.com:8080/examples/jsp/movies/wantedlist.jsp> > http://www.3idiots.com:8080/example.../wantedlist.jsp Sounds like it's a problem with your Tomcat and/or JDBC setup. Try the pgsql-jdbc mailing list for help. -- Josh Berkus Aglio Database Solutions San Francisco
It is all working now. The thing is I didn't change anything. So do you still think its Tomcat or the jdbc driver? -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Josh Berkus Sent: Thursday, September 30, 2004 12:39 PM To: Scott Dunn Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Web server to Database Taking forever Scott, > Sometimes when you click on a link on my site to access my postgres > database it takes forever for it to connect. You can click this link > and see how long it takes. > <http://www.3idiots.com:8080/examples/jsp/movies/wantedlist.jsp> > http://www.3idiots.com:8080/example.../wantedlist.jsp Sounds like it's a problem with your Tomcat and/or JDBC setup. Try the pgsql-jdbc mailing list for help. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
On Thu, 30 Sep 2004 14:58:27 -0400, Scott Dunn <sdunn@tsh.net> wrote: > It is all working now. The thing is I didn't change anything. So do you > still think its Tomcat or the jdbc driver? > a suspect might be the nature of JSP. on the first hit, JSP is converted to a Servlet, the compiled and loaded by Tomcat. consequent hits would be fast. first one is always slow. how did you connect to the database? -- stp, eyan inhale... inhale... hold... expectorate!
On Thu, 2004-09-30 at 12:58, Scott Dunn wrote: > It is all working now. The thing is I didn't change anything. So do you > still think its Tomcat or the jdbc driver? Are getting an unnaturally large number of processes or threads or pooled connections or what-not somewhere maybe? Have you tried logging output from something like top or iostat to see what's going crazy when this happens? Just wondering.