RAM requirements for a document

[rwunderlich]

jschrader asked:

"I was wondering if you could explain how to calculate the actual RAM impact that we talked about at the conference? Thanks!".

Three ways I know of to calculate the RAM requirements for a document.

1. Save the Document uncompressed (Document Properties, General, Save Format). In this case, disk size - RAM requirement. See http://qlikviewcookbook.com/2011/03/document-compression/

2. Create a .mem file from the qvw ((Document Properties, General, Memory Statistics). Load the .mem file for analysis using your own script or the QvOptimizer.qvw.

3. Use Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/ -- to get the data for a single document.

There is a bit more RAM required for each user as each user will maintain their own state.

My recollection was that you wanted to do it in batch for all docs. You could implement that with a VBScript that opened each document in turn and then called Document.SaveMemoryStatistics.

-Rob

http://masterssummit.com

http://robwunderlich.com

[jschrader]

Thanks Rob!!!