Re: bug report: slow getColumnTypeName

From: Eyal Wilde <eyal(dot)wilde(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: bug report: slow getColumnTypeName
Date: 2012-10-09 06:22:22
Message-ID: CAMiEbchygfLbpytyOdDXL3-ORjMD76u_0MqwX9QROzCkHUUp0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I verified with wireshark that getColumnTypeName indeed do a request to
the postgres server. This happens with 9.1-901 and 9.1-903 BUT NOT WITH
9.0-801!!

So, the reason for the slowness seems to be obviouse now.

it will take me some time to wrap up it into a test case. I would realy
like to help, but please let me know if it's realy necessary.
On Oct 5, 2012 1:07 AM, "Eyal Wilde" <eyal(at)impactsoft(dot)co(dot)il> 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
>
> postgres server version is 9.1.5
> jdbc version, i checked both 9.1-901 and 9.1-903
> and... BTW, 9.0-801 works good (while connected pg9.1)!
>
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message BENHAMOU Mathieu 2012-10-09 07:44:47 drop in performance using jdbc driver version 9
Previous Message Thomas Kellerer 2012-10-08 08:51:02 Minor flaw: 9.2 driver identifies itself as "devel"