Jim DeMarco
Jdemarco at hshhp.org
Fri Mar 28 07:56:26 CST 2003
Martin, Do you know if he is using replication or just controlling the threads on live data? Thanks, Jim DeMarco -----Original Message----- From: Martin Reid [mailto:mwp.reid at qub.ac.uk] Sent: Friday, March 28, 2003 8:50 AM To: accessd Subject: Re: [AccessD] MSDE Replication - Crossposted Its not a five connection limit. Its concurrent processing threads. (between 5 and 8) As more threads are added performance is throttled. You could have 400 users. Provided 390 or so of them are doing nothing performance will fly. As I said before the Technical Editor of the book we did was building one with, he said 200-300 users. Martin ----- Original Message ----- From: "Jim DeMarco" <Jdemarco at hshhp.org> To: "accessd" <accessd at databaseadvisors.com> Sent: Friday, March 28, 2003 1:23 PM Subject: RE: [AccessD] MSDE Replication - Crossposted > John, > > MSDE is SQL Server is it not? The KB article I posted yesterday gets into this a bit. Yes it will help with the 5 connection limit provided replication or more than 5 machines does not happen at the same time. If you use indirect this may not be an issue. We're looking into the same thing via a VB front-end. > > Jim DeMarco > Director of Product Development > HealthSource/Hudson Health Plan > > > -----Original Message----- > From: John W. Colby [mailto:jcolby at colbyconsulting.com] > Sent: Thursday, March 27, 2003 9:58 PM > To: AccessD > Cc: SQLServer > Subject: [AccessD] MSDE Replication - Crossposted > > > On a related note... > > MDSE claims to support replication. I don't know enough about MDSE, never > mind replication, to understand the issues - but... > > If each workstation ran MSDE and the server runs MSDE, then you have > effectively created SQL Server for more than "5 simultaneous users". Since > each user is now hitting a SQL Server Be on their own machine, with only > replication data going to the main BE on the server, it certainly sounds > like you could get fairly decent performance for 10 or 20 users. > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > ---------------------------------------------------- > Is email taking over your day? Manage your time with eMailBoss. > Try it free! http://www.eMailBoss.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > **************************************************************************** ******* > "This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". > **************************************************************************** ******* > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from HealthSource/Hudson Health Plan (HS/HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HS/HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************