Re: Database I/O Modernization

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 of it
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?