| Author |
|
sbuck
New User
Joined: May/31/2007
Location: United States
Online Status: Offline
Info: 2
|
| Added: May/31/2007 at 10:23am | IP Logged
|
|
|
What's the maximum number of users that can be handled by the MS Access database? What experience have people had with busy sites?
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1769
|
| Added: May/31/2007 at 10:44am | IP Logged
|
|
|
This really isn't the kind of application where database performance is a big issue. Mainly because the database is hardly ever accessed.
I mean it is accessed when someone logs in and then rarely after that. The admin using the admin area invloves the most database queries and that is only one person.
I have heard of people with 10,000 users in their access databases. I dont recommend it but it has been done. The problem with access databases is as they get bigger they get slower.. They just keep growing in file size. I have seen 100 mb access databases.
Truth is there is no real answer to your question. The application has no limits. The limits depend on site traffic, users, database being used, server performance and resources... etc etc etc
Since almost any good host offers SQL server nowadays as part of the base packages it's silly not to use MSSQL if your even slightly concernced about the whole thing.
Using MSSQL you can probably have many millions of users with no issues.
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
sbuck
New User
Joined: May/31/2007
Location: United States
Online Status: Offline
Info: 2
|
| Added: May/31/2007 at 1:40pm | IP Logged
|
|
|
The problem is that we run our own web server, so we'd have to buy SQL Server. For a small non-profit, not so fun.
We're running about 9,000 individual sessions a month, so it may not be a problem. Especially since I bet the traffic would drop by half if we start making people register.
Anyone got some feedback on how much requiring registration affects site traffic?
|
| Back to Top |
|
| |
cwilliams
Admin Group
CJWSoft Web Software Developer
Joined: April/06/2004
Online Status: Offline
Info: 1769
|
| Added: May/31/2007 at 3:58pm | IP Logged
|
|
|
you use the free one..
sql server express
http://msdn2.microsoft.com/en-us/sql/aa336346.aspx
some of the hosting companies even use it.. its fine
__________________
Best Regards,
Christopher Williams
www.CJWSoft.com
|
| Back to Top |
|
| |
Active Info
Memberlist
Search
Help
Register
Login
Info Locked)
Info: Max number of users
