Speed issue

[hey23]

Hi,

I used a Access database which was used by 20 people in a building(but max 4 people were using it concurrently). Since the database got bigger and bigger, I changed the backend to MySQL. Also within the form, I used VBA code to let MySQL server to execute the query. The thing frustrated me is: The speed is even lower than before! I don't know what reason it could be. Can someone experienced tell me how to find the reason and to solve it?



Some infomation about the queries I am using: INSERT and UPDATE are seldomly used, SELECT is used a lot, GROUP BY and various functions are also used a lot. Some tables are as big as 800,000 records.

Thanks! Pls let me know what else information should be provided.

[RuralGuy]

Here's a link to good performance suggestions.
http://www.granite.ab.ca/access/performancefaq.htm