topic Qlikview RAM Size and Memory Size in QlikView

Qlikview RAM Size and Memory Size

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

How is qlikview able to handle Memory shrinking? Like suppose i am loading 5 qvd's each has about 50 MB but when i am converting it into qvw file the memory is very much less. How is qlikview able to handle this? I have a little knowledge that it is due to the data model that is created by us during qvw creation. But Anyother insights on this would be a lot more helpful.

Thanks,

Vigneshwaran.M.K

Re: Qlikview RAM Size and Memory Size

tresB — Wed, 09 Nov 2016 11:50:59 GMT

QVD is a data format that can be read into qlik product very fast and that has no such algorithm of compression. Whereas, qvw is a compressed (Qlik's own algorithm) file, hence the file size is generally less than qvd.

You may want to check this discussion

Re: Qlikview RAM Size and Memory Size

jonathandienst — Wed, 09 Nov 2016 12:12:15 GMT

The compression of a QVWfile can be set to high, medium or none on the document Properties | General tab. The compression happens when the document is saved (at the end if a reload task or by the user).

The QVD format is efficient because only unique values of the symbols are stored in the symbol table coupled with a memory efficient pointer structure, but it is not compressed. A QVD will often be larger than an equivalent xlsx spreadsheet (which is compressed), but much smaller than an equivalent CSV file.