RE: Overall BPCS performance

["Graziano, Marie" <mgraziano@xxxxxxxxxxxxxxx>]

Clare:  I see you are at SSA.  Do you see and feel some resentment on
answers like, tune your machine.  I feel it's SSA's responsibility to help
customers who PAID $$$$$$ for a product that is costing us money to do
hardware upgrades, & hire more people.

We are in business to make money and if our systems like BPCS cannot handle
the workload in a FAIR amount of time, some of us will be out of business.
I heard from this list, that a company could not get orders entered and it
was causing a shutdown.  This is very poor on SSA's part.  I would hope that
YOU would know who to let know at the top or pass on the name so WE can
e-mail and voice our concerns.

Mgraziano@badgermeter.com



                -----Original Message-----
                From:   Clare.Holtham@ssa.co.uk
[mailto:Clare.Holtham@ssa.co.uk]
                Sent:   Thursday, October 08, 1998 6:14 AM
                To:     BPCS-L@midrange.com
                Subject:        RE: Overall BPCS performance

                Don't do it from PRTSQLINF, do it from STRDBMON and then
query the file -
                look only at records where 'suggested index' is YES and also
check the
                estimated processing time and size of files etc. The places
where PRTSQLINF
                indicates that the system is creating an access path may be
misleading if
                the access plan is an old one. The fact that BPCS now uses
SQL simply means
                that you now need to 'tune' the database as well, and this
could be
                different for every client as the mix of data is different
in each case.


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