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
5142
June 27, 2005 07:00AM
Re: slow search in Access with MYSQL Back End
2552
June 30, 2005 01:00PM
2459
July 07, 2005 04:49AM
2329
July 20, 2005 01:07AM
2769
July 20, 2005 12:00PM
2232
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.