I have a front end / back end database set up with multi user environment. I have front end distributed to each users computer, and a shared back end on the network. It has worked great for nearly a year, but as its grown in size and number of users, I have started experiencing database corruption almost weekly.
I am wondering if moving the backend to a mysql server and linking tables using ODBC would solve this, or if there is a better solution.
Also, I did export all my tables to a mysql backend and connected the front end just to test. Everything seemed to work fine except the fact that it is unreasonably slow.
I have one main table with customer data, and one relational table with "notes" for the customer. The main table has almost 8,000 records, and the notes table has 10,000. I have query on the front end that cuts the 8,000 records down to only about 300 records or so at the most. I then have a form that is based on that query. Is there some major design flaw that i'm missing to cause the database to be so slow? Or is that just what i'm going to get with a mysql database?