Re[2]: Evaluate complex conditions

["Eric N. Wilson" <doulos1@xxxxxxxx>]

Hello booth,

Thursday, October 26, 2000, 10:30:23 AM, you wrote:

> You suggest that an SQL process is not a performance pig compared to 
> properly written RPGIV program.   Is there any experience out there to 
> support or confute this?

It is a simple question, and the answer is simple too. A good
programmer can program circles around SQL. SQL is a general purpose
tool and therefore suffers from covering all the bases. Now a poor
programmer can make a program that will under-perform SQL and I would
even say that a mediocre programmer would hit 50-50 with SQL.

To make SQL work its best (and OPNQRYF, QMQRY, ODBC, and regular
query/400) one must build appropriate logicals and spend time dinking
around until the best performance can be found. Now do not get me
wrong, I much prefer SQL for set at a time operations and one can get
a great deal out of embedded SQL and squeeze pretty good operational
speed out of it.

But a human mind crafting the application from scratch with a good
design will always out perform a general purpose tool. Navigational
access is a real blessing and one of the few ways to support OLTP
reliably. Still this good programmer would end up creating many of the
same logicals for their program.

As far as your programmers running SQL and dogging your system out...
Well there is always the hldjob, or chgjob commands :-)

Hope that helps
Eric


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---