Peter J. Boettcher — Tue, 21 Mar 2000 13:57:00 +0000

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

JP Stones — Tue, 21 Mar 2000 11:05:00 +0000

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 — Fri, 17 Mar 2000 16:32:00 +0000

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