Need a performance tip - Statement pooling for server prepared st atements

From: VIDAL Cedric <c-vidal(at)jm-bruneau(dot)fr>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Need a performance tip - Statement pooling for server prepared st atements
Date: 2004-11-30 11:17:37
Message-ID: FB0608BA1956244694E2B71BF8B8138003240982@etudes_nt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

On the postgresql jdbc site's todo http://jdbc.postgresql.org/todo.html, it
is stated that
"statement pooling to take advantage of server prepared statements" should
be added.

Is that information up to date ? Is that feature really not supported. If
yes, does that mean, that using JDBC PreparedStatement(s) with PostgreSQL
doesn't take avantage of server side statement pooling, and thus has no
advantage over simple statements.

Either way, is there any other performance tip that could help us achieve
better performances ?

Any information on that matter would be greatly appreciated,

Thanx a lot,

Cédric Vidal

PS: We're using PostgreSQL/JDBC through Hibernate.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2004-11-30 11:32:03 Re: Bug in JDBC-Driver?
Previous Message mikael-aronsson 2004-11-30 10:14:17 Re: Maximum limit on int in plpgsql