[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
>