On 10/27/06, Derek Kalweit <[EMAIL PROTECTED]> wrote:
> Performance is really no different than the full version. I have 5 systems
> out there with 4 users on each server and the performance is more than
> adequate.
Indeed. MSDE is just as powerful as SQL Server as far as the query
engine goes, etc. The only difference performance-wise is a built-in
throttle/semaphore that prevents more than 5 queries from executing
simultaneously. You'll see notes about this in the event log if you
hit it. For many DB network apps(which don't have constant DB queries)
with 1-10 network users, you can still use MSDE without a problem.
Many thanks for the comments guys. I'll have to play around with SQL
Express to see if it's up to the job.
--
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.