You could:
1) Make sure that your data is correctly indexed (that does NOT mean that ALL fields need indices as they will slow down inserts/amends).
2) Make sure that your data is properly normalised.
3) Make sure that you open your recordsets at the last moment and close them as soon as possible.
4) Make sure that you only select relevant data.
5) Use paging.
6) Repair & compact the database.
7) Check the joins in your queries.
8) Get more RAM for your server.
9) Upgrade to SQL Server.
10) If you can't afford SQL Server, try MySql - it's free!
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.