Re: Performance & SQL coding

["Certz" <certz@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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