Re: JDBC driver build 215 slow when index contains column

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: JDBC driver build 215 slow when index contains column
Дата
Msg-id 422EF6EF.4020103@opencloud.com
обсуждение исходный текст
Ответ на JDBC driver build 215 slow when index contains column of type BIGINT  (Roland Walter <rwa@mosaic-ag.com>)
Ответы Re: JDBC driver build 215 slow when index contains column  (Roland Walter <rwa@mosaic-ag.com>)
Список 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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Roland Walter
Дата:
Сообщение: Re: JDBC driver build 215 slow when index contains column
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: FW: PreparedStatement#setString on non-string parameters