RAM consumption

Tool_Tip — Wed, 13 Nov 2024 06:53:32 GMT

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

Re: RAM consumption

Mark_Leifeld — Wed, 13 Nov 2024 09:11:28 GMT

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_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/engines-overview.htm

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-Performance-and-address/ta-p/1760292

topic Re: RAM consumption in App Development

RAM consumption

Re: RAM consumption