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: | Raw Message | Whole Thread | 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 |