Best way to calculate the qvw size for 35millions rows with 10 columns

[mayankraoka]

Hi All,

Can anyone tell me the way to calculate the QVW file size with 35 millions rows with 10 columns?

Regards,

Mayank

[Clever_Anjos]

It depends a lot of things, manly

• The length of the symbols will affect the size of the symbol table.
• The number of distinct values in a field will affect the number of rows in the symbol table as well as the length of the pointers.

Please read this Symbol Tables and Bit-Stuffed Pointers by hic‌

[mayankraoka]

Thanks Clever.

But the approx we want to calculate how can we do?

Regards,

Mayank

[Clever_Anjos]

Hard to estimate without that information.

As an example, I have an app with 65 mi records and 54 fields that uses about  900Mb