|
The real proof is in benchmarks. And I don't have time to go through them
one by one. But I should respond to your assertions.
On Fri, Sep 15, 2017 at 1:50 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:
Nathan,
Pretty much completely wrong...
You appear to have a habit of bluntness. Sometimes it works for your
benefit. But this is not one of those times.
Originally, SQL & RLA did use the same interface to the DB ...
That's an ambiguous statement. I don't believe that any SQL engine on IBM i
has ever bound to the QRNXIO service program that RPG programs bind to, nor
invoked the procedures that correspond with the op codes (open, close,
read, write, chain, etc.).
that's what's
known now as the Class Query Engine (CQE).
Again, I would challenge that the CQE ever used "the same interface to the
DB..."
You've evidently read about IBM rewriting its query engine and giving it a
new name, but you lack knowledge about its internals. Don't take that as a
put down. IBM hasn't revealed a lot of details.
But SQE was completely new, lots of stuff was added below the MI to handle
SQL operations; taking advantage of the tight integration between DB &OS.
There are some good documents out there about the SQE that make it obvious
that the new engine is using RLA under the covers.
As mere mortals working above the OS, we can't take advantage of any ofit
with RLA.
This is where your ignorance begins to show. I don't have a good reference
to point to at the moment, but IBM has indicated that DB improvements at
the MI level show up in RLA interfaces too.
End result, SQL is faster and will continue to get faster than RPG RLA.
That contradicts what I've read. Do you have a source?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD
As an Amazon Associate we earn from qualifying purchases.
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.