MySQL Forums
Forum List  »  Microsoft Access

slow search in Access with MYSQL Back End
Posted by: Sebastian Breilmann
Date: June 27, 2005 07:00AM


I use MS Access as a database Front End and MYSQL as the Back End. The main table has about 7000 entries. Everything is working fine except the serch function (strg+f) in MS Access. It takes up to a minute to find an entry. I activated the options 'Don't activate column width','Return matching rows' 'use compressed protocol', 'cahnge bigint to int' and 'allow big results'. Has anyone an idea, how to speed it up?

Greetz Sebastian

Options: ReplyQuote

Written By
slow search in Access with MYSQL Back End
June 27, 2005 07:00AM

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.