Character-based Querying and Reporting Tools User Guide > Character-based Querying and Reporting Tools User Guide > G. Troubleshooting Report-Writer > Performance Problem Troubleshooting > Performance and Conversion Function Usage
Was this helpful?
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
Last modified date: 04/03/2024