F. Troubleshooting Report-Writer : Performance Problem Troubleshooting : Performance and Memory Usage
 
Share this page                  
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 runtime 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