Paul, 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.
The only thing I can actually compare it to is SQL Server V6.5 actually running on SBS which it has replaced. The speed when extracting large queries is about 30-40% quicker on the same hardware, so it was worth the upgrade. By the way, I'm still looking for that code I promised and I'll track it down over the weekend. Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hill Sent: 27 October 2006 10:33 To: ProFox Email List Subject: Anyone used SQL Express? Hi All, I'm evaluating a client/server solution for an existing product. Does anyone have experience with SQL Express 2005 (aka MSDE) in a network environment? Pros/Cons? I'm guessing performance will be a lot lower than the full blown version. Don't care about the lack of DTS or replication. The software is used in small hotels, the number of users on average is 1-5. Obviously for larger sites a full blown SQL server would be needed but for the smaller sites (the majority) it's not commercially viable. All sites have a file server, some will possibly have a version of SQL server already if they're running something like Small Business Server. I'm not new to SQL Server, but I've always worked with the 'proper' version in companies where cost was not an issue! -- Paul [excessive quoting removed by server] _______________________________________________ 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.
