Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sarafamiglietti
Contributor

Reload Qlikview and RAM usage

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

8 Replies
MVP
MVP

Re: Reload Qlikview and RAM usage

jonas_rezende
Valued Contributor

Re: Reload Qlikview and RAM usage

Hi, Sara Famiglietti.

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

I hope this helps!

sarafamiglietti
Contributor

Re: Reload Qlikview and RAM usage

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

MVP
MVP

Re: Reload Qlikview and RAM usage

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
New Contributor II

Re: Reload Qlikview and RAM usage

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
New Contributor II

Re: Reload Qlikview and RAM usage

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

...

Highlighted
Partner
Partner

Re: Reload Qlikview and RAM usage

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
New Contributor II

Re: Reload Qlikview and RAM usage

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.