MySQL Forums
Forum List  »  Microsoft Access

Slow OBDC Connection
Posted by: Marty Owen
Date: December 28, 2012 11:01AM

I've been using Access 2007(64b) as a front-end to my organization's internet MySQL database to create stylized custom reports. Initially the website used MySQL version 3.5.1 and my ODBC connector used a 3.5.1 driver. Ad hoc query response time was good and response time for a MySQL view was very good. The website was just upgraded to MySQL 5.5.29 and as a result Access query response time has gone from a few seconds to several minutes, even on the MySQL views.

I set up a new connector using the latest driver (5.2w), however response time is still slow.

Using CPanel, query response time is very good, roughly the same as with 3.5.1. I've double checked my internet connection speed and it remains at the normal 18meg/sec download.

Any thoughts and suggestions would be greatly appreciated.


Options: ReplyQuote

Written By
Slow OBDC Connection
December 28, 2012 11:01AM

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.