I use KNIME on laptop with 2GB RAM. All nodes works well, except on "Pivoting" on large datasets (now I use dataset with 3 columns and 9 000 000 rows). This node crashes with Java heap error. At knime.ini I changesettings to:
Can I change any other settings in this case?
Thank you for the answers.
I don't think, it helps to increase the MaxPermSize in this case. You probably do better increasing the Xmx -- if possible. However, we are currently rewriting this node focusing on memory problems and functionality, such as multiple column selection for pivot/group columns and providing more aggregation methods (similar to the GroupBy node).