Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

QVD or DataSource Compression Ratio

Hello Experts,

If we load 10GB of data to Qlikview what is the QVD file size?, what is the compression ratio? Any theoritical formula behind it?

Thanks

San

Tags (1)
2 Replies
borisman
Contributor III

Re: QVD or DataSource Compression Ratio

it really depends on your data but QV is very very good at compression data so it is not rare to see 7-10 to 1 compression ratio. With my projects it was close to 10:1 a lot of times.

What you should worry though is not QVD size but the amount of RAM your final QVW will consume. Also if you will be using AccessPoint/QVS, additional users will consumer 5-10% of RAM.

I think there is a white paper about this in QlikView Scalability space. Sign up - it has a lot of good info!

neetha_p
Honored Contributor

Re: QVD or DataSource Compression Ratio

Hi San,

When you extract any data source file it stores as qvd. The qlikview stores data In QVD In encrypted form. So data are compressed In QVD.

If a data source file is of 10 MB size. When its convert into QVD then size reduces up to 90%. So in QVD size of data is near about 1 MB.

http://www.adivaconsulting.com/qlik-view-business-intelligence/item/113-data-compression-in-qlikview...

http://www.quickintelligence.co.uk/qlikview-qvd-files/

http://community.qlik.com/message/476739#476739

Regards

Neetha

Community Browser