topic Re: Database table size vs Qlikview File size in QlikView

Database table size vs Qlikview File size

Anonymous — Wed, 01 Jul 2015 10:09:34 GMT

May I know any formula or technique to find equivalent QVW size from Database table size.

Re: Database table size vs Qlikview File size

tresB — Wed, 01 Jul 2015 10:55:55 GMT

qvw size majorly depends on:

compression technique you choose (Settings->Document properties->General ...compression)
uniqueness of data (more repeated the values {data/metadata}, smaller the size and vice-versa)

If you want to learn it in depth, read: Symbol Tables and Bit-Stuffed Pointers

Re: Database table size vs Qlikview File size

hic — Wed, 01 Jul 2015 11:39:00 GMT

The technique is empirical: Load the data and see what you get... The size of the file is fairly linear to the data amount, so you can also load a subset of the data and extrapolate to make an intelligent guess.

Tresesco's answer above is absolutely correct. In addition, the database may or may not contain large amounts of indexes, so the same table may in a database sometimes use a lot of memory, sometimes a lot less.

HIC