"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 08/27/2018 12:12:00
From a performance standpoint, SQL views are no better than running
the query directly over tables. IMO comparing views & LF's is like
apples vs oranges.
I understand and I agree that SQL Views would probably be
"performance neutral" in the case of having the same SELECT statement
embedded in a program vs. built into an SQL View definition. And, as
mentioned, such an SQL View would also be shareable from any other
The problem is that some adherents make the mistake of claiming
that such embedded SQL and such SQL Views are performance neutral vs. DDS
Logical files. Given the current design, this will *never* be true.
However, I'm given to understand that embedded SQL has an
advantage over an SQL View in that SQL does save some information
regarding the embedded SQL statement within the program object where the
SQL View does not. Thus, on first-time open, it seems the embedded SQL
statement will perform *better* that opening an equivalent SQL View.