Hi Al,

There is a big difference from 405 CD and a 6.x version of BPCS.
Take invoice reprints using 405 CD - not an issue - immediate output.
Take invoice reprints using 6.X could run for hours - per invoice - even
with the logicals built in order to help performance - even on a 620
machine.

Sincerely,

Chris Ertz





MacWheel99@aol.com on 07/20/99 07:48:31 AM

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:
Subject:  Re: Performance & SQL coding

>  SQL has the coding methods to avoid poor performance, but it is very
>  easy to cause poor performance with SQL.
I am new to SQL - we converted to BPCS 405 CD from BPCS/36 last year & I am

covered up with lots of aftermath implications - one of which is learning
how
to use SQL productively.
IBM just has the single 3 day SQL class & I am signed up for it
I guess what I will need is good reference materials that advise how best
to
program in SQL/400 that avoids the bad practices of which you speak.
May I presume that those of you doing analysis of your performance dogs are

discovering that the inexperienced SQL programmers are apparently on the
staff of SSA & that these problems are not purely in-house errors of
omission, so that OSQ will have lists of upgrades needed?
There is another problem.
We have end users creating queries.
They are able to figure out which file contains the data they need, thanks
to
the wonders of external file descriptions, but my end users are not using
the
available logicals - it is almost too much to ask that a non-programmer
comprehend their importance & the performance hit taken by not using them.
Al
+---
| 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
+---


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].