Re: [DDS] [V4] Select/omit woes

Hello Vern,

Am 15.06.2021 um 14:48 schrieb Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>:

And given a SELECT over an appropriate view and include an ORDER BY as needed, performance should be good using FETCH of a CURSOR. Now on his 150 it might not be possible to get the complete update to the most recent improvements that IBM are adding all the time.

It *is* not possible: V5R2 is the latest, officially supported release. :-)

In addition, the not-quite-50 MHz Cobra CPU on that low end (but also low power and physically small) box heavily benefits from efficient coding; and SQL — at least what's available with V4 — isn't exactly efficient. That's what I got proven again by exchanging embedded SQL by a (DDS derived) LF: First, and repeated program launches are much faster than with SQL.

This finding might be different when the time required by the paging overhead of activating that SQLRPGLE program is small compared to the actual run time. My databases are comparably small, though.

I also didn't check how an SQL created view with the same functionality performs, though. I suspect that the limited SQL capabilities with V4 might now even provide all the necessary functionality.

SQL is okay for me on that box for batch workloads. :-)

:wq! PoC