Обсуждение: bad performances since 9.1 version

Hello,

I've faced slower performances since 9.1 driver version.
After some investigations, I've found metadata caching has been changed, and I have introducted a new caching method
allowingperformances to be similar than of 9.0 driver version. 

The methode implements a caching object in the AbstractJdbc2ResultSetMetaData.

Has anybody else accountered this huge slow in performances ?
Is anybody interested in testing this caching ?

Christophe

Hello Dave,

I am a "little" overbusy for now ; I have to set up GitHub but didn't had the time to do.
I also still have tests to do, the patch works fine for our software and the unit testing is OK but I have to test it
withother programs (DbVisualizer). 

Christophe

----- Mail original -----
De: "Dave Cramer" <pg@fastcrypt.com>
À: "Christophe Canovas" <cc.ais40@wanadoo.fr>
Cc: "List" <pgsql-jdbc@postgresql.org>
Envoyé: Mardi 10 Juin 2014 12:05:07
Objet: Re: [JDBC] bad performances since 9.1 version


Christophe,




Can you send this patch ?


Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



On 26 May 2014 06:23, Christophe Canovas < cc.ais40@wanadoo.fr > wrote:


Hello,

I've faced slower performances since 9.1 driver version.
After some investigations, I've found metadata caching has been changed, and I have introducted a new caching method
allowingperformances to be similar than of 9.0 driver version.  

The methode implements a caching object in the AbstractJdbc2ResultSetMetaData.

Has anybody else accountered this huge slow in performances ?
Is anybody interested in testing this caching ?

Christophe


--
Sent via pgsql-jdbc mailing list ( pgsql-jdbc@postgresql.org )
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc