* This is the modus mailing list *
As pointed out it the MSDE only allows 5 concurrent connections and
includes a 2Gb limit for each database.
Modus will normally only open 1 connection as it uses a System DNS which
will handle connection pooling for you. However, if you are using a
central Quarantine with multiple servers you would have 1 connection
from each server. You may also have a small Web App that connects to the
database to query it and present stats on your web site, which would
also use a connection.
For most users who would normally use the built-in quarantine the MSDE
provides a slightly faster interface as it will off-load the processing
to another server. If you are however running this on the same server as
Modus you will not see the performance benefits (some increase in
performance will occur due to the fact that SQL is a proper database
engine and is optimized for searching records).
---
Never have I seen a word as accurate as politics. Poly meaning many, and
tic being a blood-sucking thing.
(--------------------------------) {((((((
( Suneel Jhangiani ) /_ _ )
( Technical Director ) ( . . )
( Inter-Computer Technology Ltd. ) ( / )
(----------------------------------oOOo------------oOOo----)
( 40 James Street Tel: +44 (0) 20 7486 9601 )
( London W1U 1EU Fax: +44 (0) 7050 678 978 )
( United Kingdom Email: [EMAIL PROTECTED] )
( Website: http://www.inctech.com )
(----------------------------------------------------------)
-----Original Message-----
From: Lanham Rattan [mailto:[EMAIL PROTECTED]
Sent: 16 January 2004 18:56
To: [EMAIL PROTECTED]
Subject: [Modus] MSDE 2000
* This is the modus mailing list *
What does a concurrent connection mean? Would a connection from Modus
be
one connection or would it be the number of connections Modus is
attempting?
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Gary Carr
> Sent: Friday, January 16, 2004 10:19 AM
> To: [EMAIL PROTECTED]
> Subject: [Modus] MSDE 2000
>
>
> * This is the modus mailing list *
>
> It only allows 5 concurrent connections to the database but otherwise
it's
> the same as SQL 2000.
>
>
>
> Gary
>
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
