[AccessD] Access FE & MSDE BE?

On 15 Mar 2005 at 19:26, Dan Waters wrote:

> Is this correct?
> 
> The 25 limit is not based on the number of people logged on, but on the
> number of client computers concurrently connecting to the MSDE BE.  More can
> be logged on.
> 
OK, I've just done it bit more searching.

JC and I are both out of date with our 5. It's 8 in MSDE2000

http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnmsde2kwrk/html/msde2000webapp.asp
<quote>
MSDE 2000 employs what is known as a concurrent Workload Governor. The 
effect of the governor is to slow certain operations down by stalling user 
connections for a few milliseconds whenever there are more than eight 
concurrent operations. Some system-generated events in the database engine 
count against this eight-operation limit, so the governor may kick in even 
when your application code requests fewer than eight operations. The key is 
concurrent operations, such as executing a query. This is not the same as 
concurrent users.
</quote>

The supposed 25 limit (which appears to be an approximation of how many 
users before the slowdown becomes noticeable) comes from a number of 
different places including:  
http://www.microsoft.com/hk/sql/evaluation/overview/default.mspx
<quote>
SQL Server 2000 Desktop Engine (MSDE 2000) is a free, redistributable 
version of SQL Server. Third-party software developers can include it in 
applications they build that use SQL Server to store data. MSDE is an ideal 
solution for:
Client applications that require an embedded database.
Basic websites that serve up to 25 concurrent users.
</quote>

and http://www.microsoft.com/sql/msde/default.asp
<quote>
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, 
redistributable version of SQL Server that’s ideal for client applications 
that require an embedded database, new developers learning how to build 
data-driven applications, and Web sites serving up to 25 concurrent users.
</quote>

-- 
Stuart