"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 08/27/2018 12:12:00
PM:
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
programs.

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.


Sincerely,

Dave Clark

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].