Re: [GENERAL] JDBC performance issue

2014-02-05 Thread Dave Cramer
You said they upgraded the driver but the versions you stated are the same ??? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Wed, Feb 5, 2014 at 12:23 PM, CS DBA wrote: > Hi All; > > We have a client running Pentaho to migrate data. > > They recently upgraded Pentaho wh

Re: [GENERAL] JDBC performance issue

2014-02-05 Thread David Johnston
CS DBA wrote > Hi All; > > We have a client running Pentaho to migrate data. > > They recently upgraded Pentaho which upgraded their JDBC driver from 8.4 > (postgresql-8.4-703.jdbc4.jar) to 9.1 (postgresql-8.4-703.jdbc4.jar). > They have a test set which updates 1000 rows, with the old driver

[GENERAL] JDBC performance issue

2014-02-05 Thread CS DBA
Hi All; We have a client running Pentaho to migrate data. They recently upgraded Pentaho which upgraded their JDBC driver from 8.4 (postgresql-8.4-703.jdbc4.jar) to 9.1 (postgresql-8.4-703.jdbc4.jar). They have a test set which updates 1000 rows, with the old driver it takes about 30 seconds