×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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....
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
