Re: 9.0 Driver

Поиск
Список
Период
Сортировка
От John T. Dow
Тема Re: 9.0 Driver
Дата
Msg-id 201008090104.o7914iMR060897@web7.nidhog.com
обсуждение исходный текст
Ответ на Re: 9.0 Driver  (Scott Langley <slangley@scharp.org>)
Ответы Re: 9.0 Driver
Список pgsql-jdbc
There is, I believe, a problem with the JDBC driver in that it gives very poor performance doing a refreshRow. The
problemis that the driver queries the server for every column in the resultset. 

I implemented a quick and dirty fix by modifying the driver to (on demand) use the labels returned in the resultset.

This solution of course will fail if the original query used an alias for a column. Other than that, it seems to be a
goodsolution. 

Apparently I am the only one who uses refreshrow, because I reported the fact that it was slow in January (and there
wasa little discussion) but when in April I reported my crude solution there was no discussion. 

John


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

Предыдущее
От: Samuel Gendler
Дата:
Сообщение: Re: Java proxies connection to postgres
Следующее
От: -
Дата:
Сообщение: Re: Java proxies connection to postgres