MySQL Forums
Forum List  »  Microsoft Access

mySQL backend slower thn Access
Posted by: Jurgen Bosmans
Date: January 11, 2011 08:20AM

When i try to add say 5000 records with ADO it takes 93 sec with DAO it takes 47 sec to a mysql backend. When i add 5000 records with DAO to access backend (LAN) it takes 1 sec. I use access 2007 odbc 5.1 driver and mysql 5.5. Why is the mySQL backend with Access so slow?
When i use transactions with ADO/DAO and mysql in vba Access the job is also done in 1 sec? Does transactions make the difference or am i doing something wrong?

Edited 1 time(s). Last edit at 01/12/2011 01:18AM by Jurgen Bosmans.

Options: ReplyQuote

Written By
mySQL backend slower thn Access
January 11, 2011 08:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.