Re: More, Re: Questions about RPG service program as an SQL UDF

On 2/27/13 5:57 PM, Vernon Hamberg wrote:

I suspect that, just as it is when using a function in a WHERE clause,
that this often causes a full table scan, esp. when it is something like

function(column) = value

The bizarre and unexplained issue is that the censorship function adds
only a modest 11 seconds to the response time when I benchmark it by
counting the rows in the view (which would have to call the censorship
function for every single record), yet it adds at least 15 minutes to
the response time when a BIRT report is run. Yet when I added diagnostic
code, to log the initialization of the censorship function and each
record passed to it, running the BIRT report logged exactly one trip
through the entire file, and four additional calls to specific records.

And (based on my recollections of a class I took in Rochester back in
2005) I was under the impression that Visual Explain required one to run
the query through iNav, or something connected to iNav. How would that
help me with BIRT?

--
JHHL
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.