MySQL Forums
Forum List  »  Microsoft Access

Re: Connect MySQL via ADO or DAO (ODBC) very slow
Posted by: Robert French
Date: September 02, 2004 08:53AM

I use ado record sets to populate unbound forms. One thing l did notice has a significant impact on the speed, but not in the magnitude you are getting. Was the location of the cursor, l switched from client side cursor to a server sided cursor. You do lost some functionality eg .recordcount property for example. However for populating forms, l have found work-arounds where l used .recordcount

Options: ReplyQuote

Written By
Re: Connect MySQL via ADO or DAO (ODBC) very slow
September 02, 2004 08:53AM

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.