• Subject: Re: Performance & SQL coding
  • From: MacWheel99@xxxxxxx
  • Date: Tue, 20 Jul 1999 13:48:31 EDT

>  SQL has the coding methods to avoid poor performance, but it is very
>  easy to cause poor perfromance 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 perfomance 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.

| 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-2020 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].