[thelist] Database Licensing Question

[Ken Schaefer]

: -----Original Message-----
: From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On
: Behalf Of Richard Bennett
: Subject: Re: [thelist] Database Licensing Question
: 
: > :-) For someone on the windows platform i would say there is little
: >
: > reason to use mysql anymore.
: 
: Well... scalability would be one... MSDE is restricted to 2GB database
size,
: and 5 concurent users... and when you need to scale to MSSQL your licenses
go
: through the roof.

The 2 GB limitation will go away in the next version of SQL Server (SQL
Server 2005) which will be released in about 6 months.

The 5 concurrent user limit is incorrect - I'm not sure what you're basing
that on. There is a workload governor which limits you to 8 concurrent
operations, which is enough to support dozens (or even a hundred or more
users):

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.
asp?frame=true

for how it really works.

Cheers
Ken