MySQL + msAccess search optimization

E

Edward

I have a custom search facility on Access forms that works well - after each
user key-stroke into a search box the closest match is located in a tabular
form.



I use a Recordset Clone taken from the forms record source (multi-table
query). A 'FindFirst' is used on the clone and then the clone and the forms
recordset are synchronized.



After changing to MySQL (ODBC, InnoDB, keeping the Access front-end) the
search facility has taken a noise-dive!



Any suggestions to improve search speeds?



Thanks in advance.
 
Top