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 Memory Usage
Was this helpful?
Performance and Memory Usage
Report-Writer must allocate memory to control execution of each .print statement. Limiting the number of .print statements, as shown in Example 1, can result in significant run‑time memory savings compared to Example 2.
Example 1:
.NAME small_memory
.QUERY
   SELECT col1, col2, col3, col4
      FROM test_table
.DETAIL
      .PRINT col1, col2, col3, col4
      .NL
Example 2:
.NAME large_memory
.QUERY
   SELECT col1, col2, col3, col4
      FROM test_table
.DETAIL
      .PRINT col1
      .PRINT col2
      .PRINT col3
      .PRINT col4
      .NL
      .noformfeeds
 
Last modified date: 01/30/2023