While I agree with -borg- about scalability and performance of MSSQL,
access can do ok with web usage depending on the setup. Here are the
stats from my largest board running Access:
Launch Date of Site: February 4th, 2004 (167 days of operation)
We have 3792 Posts in 586 Topics in 17 Forum(s)
Avg Posts Per Day: 22.71
We have 9493 Forum Members
Avg New Members per day: 56.52 (excluding today)
New Members today (so far): 54 | Yesterday: 39
# of Members Visiting Site Today: 831 (excluding new members)
The main thing with Access is the concurrent connections which
can overstress a server. However, again, mine averages greater that 20
users in the Active users stats and has peaked at 150 before. Here is
the current:
There are currently 47 Active Users online, 22 Guest(s) and 25 Member(s)
Anyway, MS SQL is the best way to go as soon as you can upgrade;
however, with the right setup, access isn't too bad especially with
such a well-designed forum.
ps: here's the link to see for yourself and see how quickly mine runs
http://www.rexpage.com/myseq/forum
You can login as test:test if you like.
Topic Options
Post Options
Thanks(0)
