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

Re: JDBC driver build 215 slow when index contains column

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Roland Walter <rwa(at)mosaic-ag(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC driver build 215 slow when index contains column
Date: 2005-03-09 13:15:27
Message-ID: 422EF6EF.4020103@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-03-09 13:23:42
Subject: Re: FW: PreparedStatement#setString on non-string parameters
Previous:From: Roland WalterDate: 2005-03-09 09:39:22
Subject: Re: JDBC driver build 215 slow when index contains column

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