Thread: Web server to Database Taking forever

Web server to Database Taking forever

From
"Scott Dunn"
Date:
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.

 
Scott
 
Scott Dunn
The Software House, Inc.
513.563.7780
 

Re: Web server to Database Taking forever

From
Josh Berkus
Date:
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

Re: Web server to Database Taking forever

From
"Scott Dunn"
Date:
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


Re: Web server to Database Taking forever

From
Edwin Eyan Moragas
Date:
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!

Re: Web server to Database Taking forever

From
"Scott Marlowe"
Date:
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.