One Star

Access very slow with TOS6

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
5 REPLIES
Seventeen Stars

Re: Access very slow with TOS6

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.
One Star

Re: Access very slow with TOS6

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 ?
One Star

Re: Access very slow with TOS6

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.
One Star

Re: Access very slow with TOS6

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

Re: Access very slow with TOS6

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