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>
Re: JDBC driver build 215 slow when index contains column Oliver Jowett <oliver@opencloud.com>
Re: JDBC driver build 215 slow when index contains column Roland Walter <rwa@mosaic-ag.com>
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
Дата:
От: Oliver Jowett
Дата:
FAQ