| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: bug report: slow getColumnTypeName |
| Date: | 2012-10-06 00:47:57 |
| Message-ID: | alpine.BSO.2.00.1210052044030.25941@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Fri, 5 Oct 2012, Eyal Wilde wrote:
>
> ResultSetMetaData __md = __rs.getMetaData(); //this
> is fine
> String __sf1name = __md.getColumnName(1); //this
> is fine
> int __if1type = __md.getColumnType(1);
> //this is fine
> String __sf1type = __md.getColumnTypeName(1); //this is
> SLOW!! ~15msec
>
getColumnTypeName requires going back to the server to fetch the
additional information about the source table that is not needed for
just getColumnType. So naturally that takes longer.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2012-10-06 13:29:03 | Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver |
| Previous Message | Kris Jurka | 2012-10-06 00:43:58 | Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver |