Having fought my way through getting ODBC running with Access and MySql, I now find its like watching paint dry when I go to look at a table with Access, including scrolling down/doing a query. Is this the best I will get??? or have I missed something.
Many thanks, I have seen a few comments about indexes. I migrated my tables using the MySql Migration Kit frm Access into the database, I have looked for references to where indexes get set up but lost!! I can use HeidiSQL if I knew where to go. I am still needing to be convinced the work needed in the future to use Access as the front end will not be major. I cannot afford data to get corrupted with Primary and Foreign Keys falling over. Thanks
Thanks. This query takes 12 seconds to run, on a table with 172 rows. When the query returns the data, it takes almost the same time again to scroll to the next records in the result table. The query is performed in Access. I also changed the query once it was written in a select query to a pass through, with little if any change in speed. Regards
Thanks. This query takes 12 seconds to run, on a table with 172 rows. When the query returns the data, it takes almost the same time again to scroll to the next records in the result table. The query is performed in Access. I also changed the query once it was written in a select query to a pass through, with little if any change in speed. Regards
Thanks for trying to help. I seem to read in lots of places of people moaning about the slowness between Access and MySql. Its probably something done in Access to deter people moving away from the product. Never mind I will stay with Access until I find a way to sort it out. Thanks again.
A very big SOLVED. I went into control panel/administration settings/ODBC. I looked through the settings, and clicked on the Do Not Trace button, and hey presto it runs like lightening (well almost). So hope that helps someone else. Thanks again to all that tried helping.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.