topic Re: how will data will compress in qlikview and reloading time? in QlikView

how will data will compress in qlikview and reloading time?

pratap6699 — Tue, 29 Sep 2015 10:08:04 GMT

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 — Tue, 29 Sep 2015 10:19:49 GMT

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

nagarjuna_kotha — Tue, 29 Sep 2015 10:24:01 GMT

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 — Tue, 29 Sep 2015 10:25:21 GMT

Above is Info is all Approximately only Not exactly

Regards,

Nagarjuna