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

From Craig Ringer
Subject Re: bug report: slow getColumnTypeName
Date
Msg-id 506E6E47.7000603@ringerc.id.au
Whole thread Raw
In response to bug report: slow getColumnTypeName  (Eyal Wilde <eyal@impactsoft.co.il>)
List pgsql-jdbc
On 10/05/2012 07:07 AM, 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

Can you wrap that up into a test case (SQL schema and Java code) that's
self contained and runnable?

--
Craig Ringer


pgsql-jdbc by date:

Previous
From: Eyal Wilde
Date:
Subject: bug report: slow getColumnTypeName
Next
From: "emergency.shower@gmail.com"
Date:
Subject: Severe performance degradation when using the 9.2-1000 JDBC 4 driver