Access very slow with TOS6

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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 ?

[_AnonymousUser]

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.

[_AnonymousUser]

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

[Anonymous]

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