Reload Qlikview and RAM usage

[sarafamiglietti]

Hello,

I need to understand how Qlikview is working when loading data.

I have a document which loads 63 million of rows

The final size of this document is around 6Go, but during the reload, the RAM used is 40Go.

Why RAM usage is increasing during the reload?

Thanks&Regards

Sara

[MK_QSL]

Qlikview Server RAM Calculator.xlsx

RAM Calculation QlikView App

[jonas_rezende]

Hi, Sara Famiglietti.

The memory allocated by application in-memory. See the document attached.

I hope this helps!

[sarafamiglietti]

Hello,

Thanks for all your answers.

But all documents explained how Qlikview Server manages RAM when Users use it.

In my case, I wan't to understand how Qlikview Server manages RAM during a reload.

Regards,

Sara

[maxgro]

I think it depends on your script, above all on the number of tables, fields (distinct values) and records

If you have one small table at the end but a lot of temporary table in the script the ram grows during the load but at the end you have a small .qvw (on disk).

You can add some trace in the script, open the log file during the load and look at the windows memory of the qv.exe to identify the script section  where you have the highest RAM consumption

[denniste]

How do you do this ?  Is there a Qlikview script you can use to write out the trace statement?

*look at the windows memory of the qv.exe

[denniste]

Use the code below within your script to write out the memory usage into a text file.

EXECUTE cmd.exe /c "Del memoryusage.txt /q"   ;
EXECUTE cmd.exe /c "@echo  STEP 1 >> memoryusage.txt";
EXECUTE cmd.exe /c "tasklist /fi "imagename eq qvb.exe">> memoryusage.txt"   ;
//Qlikview script
EXECUTE cmd.exe /c "@echo  STEP 2 >> memoryusage.txt";
EXECUTE cmd.exe /c "tasklist /fi "imagename eq qvb.exe">> memoryusage.txt"   ;

//Qlikview script

...

[hectorgarcia]

hi dennis couple of quiestions:

1. do you have to insert as many steps as desired measuring points in the script?
2. the command line with tasklist /fi "imagename eq qvb.exe" do i have to copy paste as is? or what do i have to put in "imagename eq qvb.exe" part

Thanks

Hector

[denniste]

Hi Hector.

1. Yes

2. Copy paste as is.  We're pretty much running the same code but at different point during the reload process to determine the memory usage.