Query MySql Tables From Access - Too Slow!

[PurpleUnicorn]

I have an Access 2002 application in a multi-user environment, and 2 large tables (one table has 1 million records) in a mysql database. I need to query the 2 mysql tables from Access. The query runs too slow!

Are there any hints/tricks/suggestions that anyone might have for improving performance?

Thanks!

 

[cmmrfrds]

Are you using pass-through queries and limiting the rows and columns returned to the access app? How many rows need to be returned to the application - only return rows needed? Force all the processing to the server side. Have you checked on the difference is speed between ODBC and OLE-DB?

Does MySql have another interface where you can check the speed of the query.