Re: Performance and Number of Databases

[Mindaugas Bielskus <mindaugs@xxxxxxx>]

estevens@adrus.com wrote:
> 
> 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
>

I read your message on the BPCS-L user group.  I cann't offer any advice
about your specific question but I have a question of my own. 

I'll be upfront and tell you that I represent a company that sells a
data mapping utility that might be handy in your situation.  If you are
interested, please email me back and I will send you promotional info,
answer any questions and even send a demo tape.  We have had a lot of
sucess with new BPCS users.

Mindaugas Bielskus
Data Summary, Inc.

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