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)!
>
>
>
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" |