Question:
My application’s got slower after two weeks working with an Access database. Why has this happened, and how can I fix it?
Solution:
This may have happened because the database is close to its storage capacity limit, which compromises its performance and makes the application run slower.
To fix this, there are a few options:
- Enabling the database’s data discard option;
- Reducing the data discard interval;
- Creating several databases instead of having only one database and several tables.
However, the recommended option is switching databases to Oracle or SQL.
