[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

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 it

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 cs_...@consistentstate.com wrote: Hi All; We have a client running Pentaho to migrate data. They