Discussion Board for collaboration related to QlikView App Development.
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
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
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.
Above is Info is all Approximately only Not exactly