Performance and Conversion Function Usage
Conversion functions that occur as part of query processing can execute faster by up to two orders of magnitude compared to conversion function execution within the body of the report specification. Of the following two sample reports, the first report handles the conversion function most efficiently, assuming the function is being applied unconditionally to all rows retrieved.
Example 1:
.NAME query_convert
.QUERY
SELECT uppercase(col1) AS uc_col1
FROM test_table
.DETAIL
.PRINT uc_col1
.NL
Example 2:
.NAME rw_body_convert
.QUERY
SELECT col1
FROM test_table
.DETAIL
.PRINT uppercase(col1)
.NL