Click to See Complete Forum and Search --> : What kind of database (Access or SQL Srv 2005 Express) should I use for my webserver?
Pelle
07-27-2006, 12:39 PM
I am working on some webpages that should be connected to a database. I expect to have on average 100 visitors on my webserver all the time. Therefore I wonder which database is the best for my needs (at least 100 simultaneous users). The alternatives are Access 2003 and the free SQL Server 2005 Express Edition. Maybe none of these are good enough but I prefer a MS database.
Maybe you also can tell me how many simultaneous users the two databases are able to handle...
chazzy
07-27-2006, 12:58 PM
access isn't really designed for multiple connections at once to be honest.
the load will vary based on the specs of your server.
russell
07-27-2006, 01:15 PM
ez call -- use mssql 2k5, but if you're using express edition, you'll need the version with Advanced Services (http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx) for a multi-user environment.
also check out the system requirements (http://msdn2.microsoft.com/en-us/library/ms143680.aspx) and be sure to review the information in the links at the bottom of this page (http://www.microsoft.com/sql/editions/express/default.mspx)