MySQL Forums
Forum List  »  Microsoft Access

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

Hallo!

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


Subject
Views
Written By
Posted
slow search in Access with MYSQL Back End
5088
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.