Re: COM Performance...

An 'S' Model AS/400 will not necessarily give you better performance.  If
you are running Mixed Mode BPCS you may get worse performance due to the
Green Screen element.  A change to this platform should be considered
carefully.

Rather than changing SQL code, try running DBMON to check if the Optimizer
is creating Access Paths on the fly, and create Logicals accordingly.  The
overhead of adding logical's if often far outweighed by the performance
gain.







Michael Ozanne <mozanne@midori-no-ryu.demon.co.uk> on 10/07/98 05:13:59 PM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:    (bcc: Peter Greenfield/SSA/US)
Subject:  Re: COM Performance...




In message <01BDF1E4.19EC5C80@slip-129-37-183-62.sp.br.ibm.net>,
Francisco Torok <torok@mandic.com.br> writes

1)Make sure you are running on an 'S' model.
2)Edit the SQL statements so that they don't reparse complete files for
subsequent records, save the access paths for the most commonly
referenced Logicals.
3)Replace it with an alternative product, Ironworks for example.


--
Michael Ozanne (Also ozannem@pacific.co.uk)
+---
| 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
+---