I have a similar issue before - our qvw was 7GB (400 millions records) and we only have 28GB of memory to use.
No matter we play around with the memory - it keep give the user out of memory. We normalized the data and remove any possible syntetic key issue. Then finally we change the coding as well.
The code that the problem before :
=if (Age='18-49, sum (18cost) ,sum(50 cost))
what the solution is put the sum outside the if: sum(if )(age='18-49',18cost,50cost)
this reduce the calculation at the record level which create the memory issue. The guy in the forum help us and pointed the issue - any agregate function have to be outside to reduce the calculation.
That my 2 cents
Ok, I understand that these kind of situation can be solved by refining expressions .
But it is not what i'm looking so far.
I just want to limit memory usage of Qv objects and display "Out of Memory" error on charts when users open docs in Server. There is an option in Chart Properties - > General - > Memory.
But this option is only functioning when directly opening Docs using (File - Open)
How can we make use of this option in Open In Server mode.?