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
5454
June 27, 2005 07:00AM
Re: slow search in Access with MYSQL Back End
2684
June 30, 2005 01:00PM
2617
July 07, 2005 04:49AM
2478
July 20, 2005 01:07AM
2913
July 20, 2005 12:00PM
2379
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.