Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blatant attack on VFP database/tables at DevTeach
Message
 
To
14/05/2003 23:35:05
General information
Forum:
Visual FoxPro
Category:
Conferences & events
Miscellaneous
Thread ID:
00788302
Message ID:
00788516
Views:
21
Hi Al,

>Sure, you can install MSDE on an XP Pro or W2K Pro box, but you're limited to 10 connections to it so you can't reach the 20 users JD claims can be reasonably supported.

10 connections?? Oh really? That is news to me. Would you mind telling me where you're getting your information about 10 connections from? BOL clearly states that

"A concurrent workload governor limits the performance of the database engine in the Desktop Edition (MSDE). The performance of individual Transact-SQL batches is decreased when more than five batches are executed concurrently. The amount each batch is slowed down depends on how many batches over the five-batch limit are executing concurrently, and the amount of data retrieved by the individual batches. As more batches are executed concurrently, and as more data is retrieved by each batch, the more the governor slows down the individual batches. You can use the DBCC CONCURRENCYVIOLATION statement to report how often the concurrent workload governor is activated."

I'm not seeing anything about 10 connections anywhere.

I'm eager to hear where you got your information from.
Jim Duffy
Microsoft MVP
INETA Speaker
TakeNote Technologies
Developer's Choice Award Winner for Best Training Company
Specializing in VB.NET, ASP.NET, VFP, and SQL Server Training and Development
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform