Re: bug report: slow getColumnTypeName

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
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-05 05:21:11
Message-ID: 506E6E47.7000603@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message emergency.shower@gmail.com 2012-10-05 19:27:15 Severe performance degradation when using the 9.2-1000 JDBC 4 driver
Previous Message Eyal Wilde 2012-10-04 23:07:40 bug report: slow getColumnTypeName