how will data will compress in qlikview and reloading time?

[pratap6699]

hello friends and experts, i hope any one can clarify my doubts,

suppose i have 50millions of records source table is there how much this table size approximatly?

after this table loading into QV, how much time it takes to reload?

after reload final QVW size?

next same 50 millions records data strored into QVD, then qvd size?

after that qvw size?

please give me answers quickly

[swuehl]

That's hard to tell for a specific unknown data source. It depends - mostly on the distinctness of your data values.

If you search for compression ratio, you will find a lot of threads here in the forum that discuss this in general, like

QVD or DataSource Compression Ratio‌

Re: Shrink ratio in QVD and QVW files

[nagarjuna_kotha]

Hi Pratap,

We can't say exact size and reload time its based on data that is having columns .

Size : If the file have one column  its approximately 1-2 MB

Read Time : If i.e Excel 2-3 Minits

                  If i.e QVD 1 min and Size is its compressed 80% of source file.

Regards,

Nagarjuna

[nagarjuna_kotha]

Above is Info is all Approximately only Not exactly

Regards,

Nagarjuna