Purpose
To change the amount of memory Connect ETL uses for data storage.
Format
/MEMORY amount
where
| amount | = | number | {KILOBYTES} {MEGABYTES} {GIGABYTES} {TERABYTES} |
Arguments
| number | The maximum amount of memory Connect ETL is to use for data, in the unit specified. |
Location
The option may appear anywhere in the task definition.
Notes
Connect ETL uses an amount of main memory sufficient to perform the task efficiently without impacting other users on the system. You may want to use the /MEMORY option to change dmexpress’s default behavior in the following cases:
- If your system has limited memory and there is the possibility of excessive paging, you can specify a limit to the amount of memory that Connect ETL is able to use. Limiting memory in this manner will probably increase the time and possibly the disk space that Connect ETL uses.
- If your input data is less than the total main memory on your system, you may be able to reduce sort time and disk space usage by specifying a memory value greater than your data size but less than your system’s physical memory. In this case, Connect ETL attempts to perform the sort in memory.
- If Connect ETL issues a message to indicate that more memory would improve performance.
It is recommended that you do not specify a memory value greater than the available physical memory on your processor.
Example
/memory 1.2 megabytes The option specifies that Connect ETL can only use 1.2 megabytes to store
data.
/memory 75 gigabytes The option specifies that Connect ETL can use 75 gigabytes to store data.