Postgres Pro
Downloads
Home   >   mailing lists

Re: JDBC driver build 215 slow when index contains column - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBC driver build 215 slow when index contains column
Date
Msg-id 422EF6EF.4020103@opencloud.com
Whole thread Raw
In response to JDBC driver build 215 slow when index contains column of type BIGINT  (Roland Walter <rwa@mosaic-ag.com>)
Responses Re: JDBC driver build 215 slow when index contains column  (Roland Walter <rwa@mosaic-ag.com>)
List pgsql-jdbc
Tree view 
Roland Walter wrote:
> I use PostgreSQL 7.4.6 and the JDBC-driver build 215. [...]

> Have I to do a typecast to ::bigint with build 215 in the PreparedStatement
> to get the same performance as with build 310?

Against a 7.4.x server, yes.

> That would be bad, as I
> had to
> form the PreparedStatement incompatible to other databases.

Why can't you use build 310? It's intended to work against 7.4.x servers
as well as 8.0.x.

-O

pgsql-jdbc by date:

Previous
From: Roland Walter
Date:
Subject: Re: JDBC driver build 215 slow when index contains column
Next
From: Oliver Jowett
Date:
Subject: Re: FW: PreparedStatement#setString on non-string parameters