| From: | "John T(dot) Dow" <john(at)johntdow(dot)com> |
|---|---|
| To: | "pgsql-jdbc" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: 9.0 Driver |
| Date: | 2010-08-09 00:55:19 |
| Message-ID: | 201008090104.o7914iMR060897@web7.nidhog.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
There is, I believe, a problem with the JDBC driver in that it gives very poor performance doing a refreshRow. The problem is 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 good solution.
Apparently I am the only one who uses refreshrow, because I reported the fact that it was slow in January (and there was a little discussion) but when in April I reported my crude solution there was no discussion.
John
| From | Date | Subject | |
|---|---|---|---|
| Next Message | - | 2010-08-09 10:34:26 | Re: Java proxies connection to postgres |
| Previous Message | Samuel Gendler | 2010-08-08 17:32:58 | Re: Java proxies connection to postgres |