Re: About BPCS V6.1.01 MM

[DAsmussen@xxxxxxx]

Marie,

In a message dated 9/20/00 7:33:29 PM Eastern Daylight Time, 
mgraziano@badgermeter.com writes:

> Well that is ok to call SSA.  But we have proven out our logicals.  When we
>  called Helpline noone had any answers.  IF SSA is aware of performance
>  problems, then they should publish them.  We had our invoicing go from 8+
>  hours down to 45 minutes with our inhouse logical.  SSA cant beat that! 
>   Thanks for the update. We will stick with our inhouse logicals

Yes, SSA _should_ provide some rather intuitive logicals, look at ECHW and 
ECLW and, as someone that doesn't even know SQL, tell me what intuitive 
logicals are missing.  However, the rest of performance logicals are highly 
subjective based upon your configuration and usage of BPCS.  What would be a 
boon to one site could prove to be a bain to another.  The SQL optimizer 
evaluates access paths based upon creation date, not usefulness.  If you 
don't do the analysis, you could end up creating a logical that would destroy 
otherwise optimal performance.  DBMON doesn't always provide accurate 
results, and the ability to evaluate those results based upon your own 
database is required.

SSA evaluates performance based upon a minimalized database, not 500K records 
in ITH or HPO.  Each company is different, and don't let anyone tell you how 
to optimize your database without a thorough analysis...

JMHO,

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

"Quitting smoking is the easiest thing to do.  I've done it thousands of 
times." -- Mark Twain
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@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
+---