RE: Need 2 cents on multiple libraries

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 11:10 AM 3/17/00 -0500, you wrote:

I disagree.  You may well at some point need cross-branch 
information.  Combining the libraries later will be a lot of work.  I 
prefer a field by branch.

Al - in San Diego


>In your shoes, I would add "yet" to "no shared information between the
>branches".  That said, I would definitely not recommend the multiple library
>approach.  In my opinion, it would be unncecessarily cumbersome and make it
>difficult to add branches later.  One library containing files with a member
>for each branch would be more practical, I think.
>
>Having said that, files with multiple members make consolidated reporting
>rather difficult.  I personally believe there is no substitute for using
>primary keys, like a branch number, for tracking and extracting information.
>
>As always, just my opinion.
>
>Donald R. Fisher, III
>Project Manager
>Heilig-Meyers Furniture Company
>(804) 784-7500 ext. 2124
>Don.Fisher@HeiligMeyers.com
>
><clip>
>  We are debating between using one database library per branch
>vs. a branch code field key and one library.  These files will be large
>and in use 24 hours per day and there will be no shared information
>between the branches.  May I have your comments on your experience with
>using either/or.  TIA   Julie
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---



+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:          914-251-1234
Fax:            914-251-9406
http://www.barsaconsulting.com
http://www.taatool.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---