Perhaps there are other benefits to SQL for single-record access besides just performance?!

- SQL can access non-IBMi databases. (with appropriate driver installed)
- SQL can read only the needed fields from a record (instead of all)
- SQL doesn't get "level check" errors.
- SQL can do lookups on fields that DON'T have an index built over them

You might be able to think of more advantages than that if you try.

Don't get me wrong: There are times when performance is paramount, and when that time comes, you'll probably find me using RLA instead of SQL.

But, in perhaps 95% of the cases, the difference between 1 nanosecond and 6 nanoseconds just doesn't matter.

On 4/4/2012 3:33 PM, Charles Wilt wrote:

But the fact of the matter is a SQL SELECT INTO could only ever be as
fast as an RPG CHAIN....never faster...and it certainly wasn't even as
fast a few years ago. Perhaps that's changed.

Still, IMHO it's pointless to simply replace RPG RLA with SQL RLA....

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