Discussion Board for collaboration on QlikView Performance.
i have an app with 3 pivot table and 3 inputfield (what if analysis)
The size it's 600 mega, but when i open the file (on server), uses 15 giga of RAM (of 32 on server). Too when i only save the file.
First pivot table has 70 k id distinct and 180 column (1 for every day)
Second pivot it's for weekly, then only 15 column.
Third pivot it's with 365 column
If delete 3 inputfield the size reduce at 120 mega and uses 2 giga of RAM.
This .qvw It's called from another .qvw passing parameters including the id. that reduce a pivot in a record.
More time when i try to open the qvw on access point i receive session timeout error and i have seen that the giga arrive at 28 (of 32).
Then the problem It seems to be the inputfield.
There is somethings that i can do?
I already used analyzer to delete field not used
Are you creating the INPUTFIELD in script ?? or your making use of the variables in the UI inputbox ??
This post may give an insight on what is happening How tp find the size of RAM. | Qlik Community
in the script:
INPUTFIELD [Initial On-hand quantity WIF] ,[Requirement quantity WIF],[Shipped Quantity WIF]
can u help me with this information? (order by bytes order by size)
In 2° photo the first 3 are the inputfield.