Saving retrieved rows to disk

If you want to maximize the amount of memory available to Sybase WorkSpace and other running applications, Sybase WorkSpace can save retrieved data on your hard disk in a temporary file rather than keep the data in memory. Sybase WorkSpace 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, Sybase WorkSpace swaps rows of data from the temporary file into memory instead of keeping all the retrieved rows of data in memory.