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: [PERFORM] Web server to Database Taking forever
On Thu, 30 Sep 2004 14:58:27 -0400, Scott Dunn [EMAIL PROTECTED] 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! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [PERFORM] Web server to Database Taking forever
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. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org