Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarafamiglietti
Creator
Creator

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
jonas_rezende
Specialist
Specialist

Hi, Sara Famiglietti.

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

I hope this helps!

sarafamiglietti
Creator
Creator
Author

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
MVP
MVP

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

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

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
Partner - Creator III
Partner - Creator III

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

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.