Re: Very strange performance decrease when reusing a PreparedStatement

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Péter Kovács <maxottovonstirlitz(at)gmail(dot)com>
Cc: Roland Roberts <roland(at)astrofoto(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Very strange performance decrease when reusing a PreparedStatement
Date: 2009-05-04 00:00:01
Message-ID: 49FE3001.40006@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Péter Kovács wrote:

> Regardless of what Oracle can or cannot do, the question stays put:
> Can precompiled Postgres SQL statements handle varying parameters?

Yes.

> If
> they can (and people here say they can), why doesn't the JDBC
> PreparedStatement take advantage of it?

It does.

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2009-05-04 00:32:30 Re: Unit test patches
Previous Message Oliver Jowett 2009-05-03 23:51:10 Re: Very strange performance decrease when reusing a PreparedStatement