RAM and how reduce the size of qvw

[demcug82]

Hi All,

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?

P.s.

I already used analyzer to delete field not used

[avinashelite]

Are you creating the INPUTFIELD in script ?? or your making use of the variables in the UI inputbox ??

[Colin-Albert]

This post may give an insight on what is happening   How tp find the size of RAM. | Qlik Community

[demcug82]

in the script:

INPUTFIELD  [Initial On-hand quantity WIF] ,[Requirement quantity WIF],[Shipped Quantity WIF]

[demcug82]

Hi Colin,

can u help me with this information?  (order by bytes order by size)

In 2° photo the first 3 are the inputfield.