How do I make a DB faster?
March 26, 2010 1:00 PM Subscribe
MS Access: How do I turn my database from a tortoise to a hare? (Or, if not a hare, a chipmunk?)
posted by Vavuzi to computers & internet (8 answers total) 1 user marked this as a favorite
Here's what I've got:
MS Access DB split into front and back ends. Front sits on local machines (all XP), back sits on server (MS Server 2003). I have a consultant for the DB and a consultant for the network.
When there's one and only one user connected to the back end, the DB is lightning fast. UNBELIEVABLY fast. The minute that more than one user is connected, everything slows to a crawl. It's been this way for 2.5 years and it drives me nuts. The DB guy blames the network, the network guy blames the DB. Initially, I couldn't tell if it was the network or the DB. I'm now convinced it's the DB.
I've read past questions and googled.
It looks like Access falls to shit once it hits around 50 users. The most we ever have is 7. It doesn't get slower as more users come online: one user = fast, more than one = slow. It runs at the same speed for 7 users as it does for 2.
Is it possible to get the DB running faster or is this as good as it gets? If so, where/how do I start? Any suggestions welcome; I'm willing/wanting to learn so that I can work with my DB guy.