Re: Performance and Number of Databases

[DAsmussen <DAsmussen@xxxxxxx>]

Ed,

In a message dated 98-03-19 17:03:52 EST, you write:

> I haven't the knowledge of the sizes of the db verses the power of your 
>  equipment to help you make a decision based on that info, but I do have 
>  this experience:  It all boils down to just how simular each site is and 
>  how much consolidation of info is required.  If each site can stand on it's
>  own and G/L consolidations aren't necessary or can be accomplished in a 
>  simple way than separate is better.  Any sharing of data or reporting or 
>  financial sharing or business decision processes that are common require 
>  you to beef-up you resources at a center location with one db. 

I cannot agree more.  If you want the (impossible) goal of centralized
planning and/or accounting, then MFS, DRP, and a single database are the way
to go.  BE FOREWARNED -- with the SQL in V6, larger databases=slower
performance.

JMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"I don't know the key to success, but the key to failure is trying to please
everybody." -- Bill Cosby
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---