Jump to content

server-side dB performance in Access


dBrococo
 Share

Recommended Posts

Hi all,I am programming an Access 2000 database that contains approximately 3700 records stored in a relational table structure.When I split the database and moved the tables to the server side, my performance worsened drastically: a query that runs in under 5 seconds when the tables are on the client side takes over 45 seconds with tables on the server side.I've tried a variety of solutions (changing the subdatasheet name property to [None] in the tables, creating an MDE file from the MDB file), but they haven't helped.Any suggestions about how to speed performance are greatly appreciated! Thanks a lot!

Link to comment
Share on other sites

I think you'll find that Access itself is the problem. Access is not intended or optimized to be an online database plus Access does have it's limits after it gets a lot of data it begins to chug. I would suggest you upgrade to MySql or Sql Server.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...