Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
As shown in below picture, the RAM consumption is almost 60GB while loading 12.5 Million records,
Just need to understand why there is big difference that to load 12.5 million records will it consume 60GB of RAM?
RAM CONSUMPTION:
Table load:
Note: There is no any other task running in parallel. Only single task
Hi @Tool_Tip,
rownumbers is just one part you can use to estimate the needed ram.
It also depends on how much columns the table has and what type of data you are loading.
Loading just number is not a big problem but if you load large text field or lots of long disitinct keys it could consume much memory.
Also consider, the engine service is not only used for reloads --> https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployA...
Here is a good community post on how to address high ram consumption https://community.qlik.com/t5/Official-Support-Articles/How-to-start-investigating-Qlik-Sense-Perfor...