Increase the Memory Limit in PDI
Pentaho Data Integration's startup script uses the default memory settings for your Java environment, which may be insufficient for your work. If you're experiencing an OutOfMemory exception, you must increase the amount of heap space available to PDI by changing the Java options that set memory allocation. Follow the directions below to accomplish this.
- Exit Spoon if it is currently running.
- Edit your Spoon startup script and modify the -Xmx value so that it specifies a larger upper memory limit.
- Start Spoon and ensure that there are no memory-related exceptions.
The Java virtual machine instance that the Pentaho Server uses now has access to more heap space, which should solve OutOfMemory exceptions and increase performance.