MySQL Forums
Forum List  »  Microsoft Access

Re: slow search in Access with MYSQL Back End
Posted by: Mike Hillyer
Date: June 30, 2005 01:00PM

Is your table indexed? If you have no index on the column you are searching on this could be causing table scans. Are Access and MySQL on the same machine? If not, watch network traffic as you run the query. If you have a lot of traffic Access may be pulling all 7000 rows and scanning them in memory rather than letting MySQL do the search.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870
Blog: http://www.openwin.org/mike

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: slow search in Access with MYSQL Back End
2527
June 30, 2005 01:00PM


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.