Specifications

Retrieving data
234 InfoMaker
Retrieve Rows As Needed is overridden if you have specified sorting or have
used aggregate functions, such as
Avg and Sum, in the report. This is because
InfoMaker must retrieve every row before it can sort or perform aggregates.
In a multiuser situation, Retrieve Rows As Needed might lock other people out
of the tables.
Saving retrieved rows to disk
If you want to maximize the amount of memory available to InfoMaker and
other running applications, InfoMaker can save retrieved data on your hard
disk in a temporary file rather than keep the data in memory. InfoMaker swaps
rows of data from the temporary file into memory as needed to display data.
❖ To maximize available memory by saving retrieved rows to disk:
• Select Rows>Retrieve Options>Rows to Disk from the menu bar.
With this setting, when displaying data, InfoMaker swaps rows of data
from the temporary file into memory instead of keeping all the retrieved
rows of data in memory.