BP just spawns a new document file when it approaches 2Gb, so MSDE will
continue to serve us for some time into the future.
Neil D. McAliece wrote:
----- Original Message -----
From: Ian Cheong <[EMAIL PROTECTED]>
To: General Practice Computing Group Talk <[email protected]>
Sent: Thu 22 Dec 2005 02:24:59 EST
Subject: Re: [GPCG_TALK] Picking another package other than MD2
....snip...
I suspect we might be able to live with the 8 concurrent process
governor on MSDE, but will probably blow the 2GB database limit if we
do any scanning (our present MD2 database is about 1GB). Or perhaps
that is why BP has multiple smaller SQL databases????
Possibly. Can anyone confirm that this is the reason for multiple db? Is there
a doc database and the system just spawns a new one at a certain size? In the
case of MD3 there is a document manager to store the scans and attachments in
the filesystem with only references in the database, so I can't imagine needing
more than 2GB in the database.
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk