Performance and Number of Databases

[estevens@xxxxxxxxx]

My company is preparing to implement BPCS in an AS/400 environment.  We
have several manufacturing plants scattered across the US.  Currently, we
have a raging debate over whether to configure a single large database or
multiple databases by plant.  Each choice has trade-offs but so far,
nothing has surfaced that has been sufficiently compelling to tip the
scales one way or the other.

Does anybody have any sage wisdom on this?  What might be the performance
implications of accessing a single large DB versus a multiple DB scenario?
If we choose wrong, would it be easier to consolidate multiple DB's at a
later date or easier to break up a single DB into smaller ones?

Thanks in advance,

       ......Eric


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