Re: slow search in Access with MYSQL Back End
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
Subject
Views
Written By
Posted
5155
June 27, 2005 07:00AM
Re: slow search in Access with MYSQL Back End
2556
June 30, 2005 01:00PM
2465
July 07, 2005 04:49AM
2333
July 20, 2005 01:07AM
2773
July 20, 2005 12:00PM
2236
August 19, 2005 10:47AM
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.