 tmcquinlan wrote:
MSDE was originally offered as a free developers version of SQL but is now often used for desktop apps that are designed for a single user.
The biggest reason you won't want to use it for a discussion forum is that it has an inbuilt maximum of 5 users. It will allow more users to connect, but performance will be seriously, purposely, degraded over 5.
|
http://www.aspfaq.com/show.asp?id=2343
Specifically concerning the "concurrent users", the aboive statement is not 100% correct.
"MSDE 2000 allows 32,767 connections to an instance of the database engine. There is no limit for the number of connections that can be executing operations at the same time. The only effect of the workload governor is that it starts slowing down the database engine when more than eight operations are actively running at the same time."
and
"Once it has been activated, the workload governor limits performance by stalling a user connection for a few milliseconds each time the connection requests a logical read or write on any of the pages in the data files of a database"
and
"When the number of active operations is eight or lower, the database engine does not wait before scheduling any reads or writes. When the workload governor is active, it equally affects all connections; it is not limited to slowing down only the connections that activated the governor. The length of the wait implemented by the governor is constant (it does not vary depending on how many operations are active beyond the limit of eight)."
Given that an "operation" will only last milliseconds anyway ... the impact when compared to an access database will be very very minimal.
Id consider MSDE a far better option than an access database
Topic Options
Post Options
Thanks(0)
