I have a MySQl database on the backend of an Access front end where multiple users update client information as calls come into the company. All of the data is now linked into Access from linked tables. The problem is the response time when they are adding records. It's not a heavy volume at all but there are about 10 users updating at the same time. All users are set up under one username thread, as this was an easier way to set up the ODBC connection. (Is that the right way to go?)
My question is...what are the optimization parameters that I should be adjusting? I am sure it has to do with the cache and the amount of memory being met for disk writes. (Is this correct?)
My question is...what are the optimization parameters that I should be adjusting? I am sure it has to do with the cache and the amount of memory being met for disk writes. (Is this correct?)