How many simultaneous users can Access handle?
Hi,
Does anyone knows how many simultaneous users can Access handle? I am using this databases through IIS. Btw there are around 6 tables in there.
Thanx
Coddy
Hi,
Does anyone knows how many simultaneous users can Access handle? I am using this databases through IIS. Btw there are around 6 tables in there.
Thanx
Coddy
Peter J. Boettcher posted this at 16:32 — 17th March 2000.
They have: 812 posts
Joined: Feb 2000
Coddy,
Access is good for roughly 10-20 users at the same time, after that things will get really slow and you'll start getting timeout errors.
Access 2000 is a little better, probably up to maybe 30 users at the same time.
When I was at Microsoft a couple of months ago they said that Access could handle no more than 5-10 users reliably, but this was at a SQL 7.0 seminar so I'm not so sure they were being objective.
Regards,
Peter J. Boettcher
PJ | Are we there yet?
pjboettcher.com
JP Stones posted this at 11:05 — 21st March 2000.
They have: 2,390 posts
Joined: Nov 1998
I'm about to set up mySQL for my DB for a Mailling Program and What Next? - how many users can that handle?
It is better than mSQL right?
cheers,
JP
Peter J. Boettcher posted this at 13:57 — 21st March 2000.
They have: 812 posts
Joined: Feb 2000
JP,
mySQL should have no problem handling up to 500,000 users.
The consensus is that mySQL is better than mSQL, since mySQL is basically a superset of mSQL.
One note though, if your db get's that large (500,000) I would recommend going to a dedicated solution (SQL 7,Oracle, etc) since you could then take advantage of triggers, and some more advanced stuff like rollbacks, commits, etc. Although I think they may be adding this functionality to mySQL sometime soon.
Regards,
Peter J. Boettcher
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.