Re: File Encapsulation Quandary

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Charles,

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