From: | "Dr(dot) Evil" <drevil(at)sidereal(dot)kz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | JDBC 2.0 and pooled connections? |
Date: | 2001-10-11 08:23:23 |
Message-ID: | 20011011082323.6035.qmail@sidereal.kz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
With PG, there is a fork every time a connection is started. This is
expensive, and my web application will need to have a connection from
every page it serves. The right way to do this is to have the servlet
maintain a connection pool.
What's the right way to do this with PG's JDBC driver? I notice that
there is a class for JDBC 2.0 in PG 7.1.x, and JDBC supports a
DataSource interface which could do pooling. Does anyone know if it
actually does pooling, and if so, do you have any example code of how
this would work in a servlet? This will be a tremendous performance
boost. It will cut page load time by 75% I would imagine.
Thanks for any tips. Btw, this is all with JDK 1.3.1, PG 7.1.2, and
Tomcat 4.0, so it's all modern stuff.
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2001-10-11 10:04:33 | Multiple postgresql installations on one machine. |
Previous Message | tony | 2001-10-11 07:55:01 | Re: Performance problem with 50,000,000 rows |