Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
pratap6699
Creator
Creator

how will data will compress in qlikview and reloading time?

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

3 Replies
swuehl
MVP
MVP

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
Partner - Specialist II
Partner - Specialist II

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
Partner - Specialist II
Partner - Specialist II

Above is Info is all Approximately only Not exactly

Regards,

Nagarjuna