Re: bug report: slow getColumnTypeName - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: bug report: slow getColumnTypeName
Date
Msg-id alpine.BSO.2.00.1210052044030.25941@leary.csoft.net
Whole thread Raw
In response to bug report: slow getColumnTypeName  (Eyal Wilde <eyal@impactsoft.co.il>)
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Next
From: Dave Cramer
Date:
Subject: Re: Severe performance degradation when using the 9.2-1000 JDBC 4 driver