Skip site navigation (1) Skip section navigation (2)

Need a performance tip - Statement pooling for server prepared statements

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 statements
Date: 2004-11-30 11:17:37
Message-ID: FB0608BA1956244694E2B71BF8B8138003240982@etudes_nt (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group