Slow Workflow and System characteristics

Dears
I 'm facing struggles to run Workflows with kind of 23 Mil row and 83 Column, in the same time there are SAP_HANA Designer also running a queries.

It happened that every thing freeze suddenly and nothing work. the execution sometime takes hours to run ! and the DATA App connected became very slow

hereunder Screen of the System characteristics.
is there anything i can enhance?

111

Hi @RamyHussein

Maybe you find something usefull in this blogpost?

gr. Hans

1 Like

Thank you @HansS
as what i read right now, i should have no problem at all.

So why my flows are very slow!
is there specific System Requ. needed for KNIME 5.2.5?

I am experiencing the same issues with the new version (5.2.5) of KNIME. Doesn’t throw any error/warning. The UI simply freezes, and my entire laptop stops responding. This problem did not occur with version 4.7.0. Since upgrading (last month), I have not been able to run my workflow to completion even once.

System Configuration:
Installed RAM: 8.00 GB (7.86 GB usable)
Processor: Intel(R) Core™ i5-7300U CPU @ 2.60GHz 2.71 GHz
System Type: 64-bit operating system, x64-based processor

@RamyHussein @Khushboo_Yadav how much RAM so you have assigned to knime?

How large is the data you are processing when zipped.

You might try to switch from Raw based compression to columnar based compression (in the settings) but maybe test it on a copy of your workflow.

2 Likes