topic Re: Access very slow with TOS6 in Talend Studio

Access very slow with TOS6

Anonymous — Wed, 03 Aug 2016 14:25:43 GMT

Hello,
I created a job in TOS 6.2.1 with access 2002-2003 database.
It works but it is very slow (about 0.5 row/s).
The same job with the same request in TOS 5.6.3 is really faster (about 100 row/s).
The mdb file is the same for both job. My request uses 4 join tables.
Talend 5.6.3 uses odbc driver instead of ucanaccess jdbc driver.
I know that odbc driver is no longer supported in TOS 6 with java 8.
Is there any parameters in my Access connection to have faster results ?
Thanks

Re: Access very slow with TOS6

Anonymous — Wed, 03 Aug 2016 23:13:27 GMT

Throw away this Access crap! I suggest you unload all the data with TOS 5.x and use a real database for your application.
At least you could use the SQL Server. anything is better than Access.

Re: Access very slow with TOS6

Anonymous — Thu, 04 Aug 2016 07:04:46 GMT

Yes, sure but it's not a development, it's a commercial software so i can't change the database as I want.
Nobody have problem with ucanaccess ?

Re: Access very slow with TOS6

_AnonymousUser — Mon, 08 Aug 2016 18:30:39 GMT

You have to pay attention at the autocommit connection property. If you do a commit just each 100/200 records, performances will improve dramatically with ucanaccess.

Re: Access very slow with TOS6

_AnonymousUser — Tue, 09 Aug 2016 22:42:33 GMT

Obviosly I meant autocommit must be set to false and commit called explicitly

Re: Access very slow with TOS6

Anonymous — Mon, 22 Aug 2016 12:36:58 GMT

I have the problem when i declare a metadata connection and check it.
I don't see autocommit option at this step.