I'm currently running a Snitz forum with a MS Access 2000 Database.
How many users can access my forum at a time? I have experienced that Snitz forums are a bit slow when using Access databases. Does that also depend on the amount of users accessing the forum at the same time?
Access is a desktop database and was never intended to be used on the internet/support mulitple users. From past experience I would say that it would struggle with more than 20 concurrent users.. Thats why larger sites use Microsoft SQL or MYSQL..
quote: Access is a desktop database and was never intended to be used on the internet/support mulitple users. From past experience I would say that it would struggle with more than 20 concurrent users.. Thats why larger sites use Microsoft SQL or MYSQL..
Hope this has helped..
--BIB
Edited by - BIB on 13 April 2001 07:27:32
While it is correct to say that access was designed as a desktop DB, it can take a lot more than 20 users before it will start to 'struggle' to a database, concurrent means 20 users all issuing a query at the same time, this is generally an unlikely event, and access will perform quite happily with several hundred users. It's performance will be affected more by the number of posts and the DB size than the number of concurrent users.
Topic Locked
Posted - 09 April 2001 : 03:42:46
