When connecting Microsoft Access to a MySql database using ODBC connections, every query ran takes forever and shows up in the slow query log

When connecting Microsoft Access to a MySql database using ODBC connections, every query ran takes forever and shows up in the slow query log.

I just got a new job at a small开发者_高级运维 company, their entire system is based around Microsoft Access and MySql, and it's so flapping slow.

My job is to create a replacement, but I want to speed up the current system in the meantime, any suggestions?

Cheers Guys

Try using "EXPLAIN" to look at how efficient the queries are. It is possible that they aren't using indexes.

It is also possible that you need to increase the size of your key_buffer_size (in mysql.ini). MySQL loves a large key cache!