topic Re: QVD PURPOSE in QlikView

QVD PURPOSE

Mon, 17 Feb 2014 07:44:41 GMT

what is the purpose of qvd and internal how it is work in qlikview? PLZ TELL ME ANYONE....

Re: QVD PURPOSE

luis_pimentel — Mon, 17 Feb 2014 07:49:19 GMT

Most of the times, I prefer storing the data into QVD's as a first step. Basically this enables me;

1. Join data from various resources in a single file,

2. Add new calculated fields at once and store them in the QVD so that they will be available for use at any time,

3. Simplify the load script of the end-user QVW and thus substantially reduce the reload time of the end-user
document .

Hope this helps.

Regards,

Re: QVD PURPOSE

Mon, 17 Feb 2014 07:49:46 GMT

QVD's are internal storage in qlikview .these are compressed files.generally we get the tables from different sources we store them into QVD's.Loading data from QVD's are 10 to 100 times faster than fetching the data from normal tables.

Advantages:

1) Reduce the network traffic because we store tables internally as QVD

2) No burden on DB.

regards

Mahesh T

Re: QVD PURPOSE

Mon, 17 Feb 2014 07:50:57 GMT

1) Faster Data Reloading Compare original Data Sources

2)Require less Memory to store

3) useful in incremental load

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

Re: QVD PURPOSE

Mon, 17 Feb 2014 07:58:13 GMT

One more advantage :

Incremental Load can be done only by using QVD's

Regards,

Divya

Re: QVD PURPOSE

Mon, 17 Feb 2014 08:01:53 GMT

K THANK YOU but how it is work internally means(internal structure ) of QVD

Re: QVD PURPOSE

Mon, 17 Feb 2014 08:14:09 GMT

A QVD stores ONE table, quite the same way as QV stores this table in memory

it is why the load is very fast : everything is organized in the QVD as it should be in QV

Because it is so fast, we store part of the data of an application in the QVD, and part of the data must be fetched in the source files or databases.

Fabrice

Re: QVD PURPOSE

Anonymous — Mon, 17 Feb 2014 08:27:17 GMT

Hi Fabrice,

Will a QVD help to make the application faster? Or is it just reducing the reload time?

Kind regards,

Henco

Re: QVD PURPOSE

salto — Mon, 17 Feb 2014 08:29:48 GMT

Hi Henco,

Just the reload. Once the data is loaded it is in memory, the QVD file (or any other data source) is not loaded anymore.

Regards.

Re: QVD PURPOSE

suniljain — Mon, 17 Feb 2014 08:31:49 GMT

QVD makes data load faster becasue its native format of QlikView.

Re: QVD PURPOSE

Mon, 17 Feb 2014 08:32:05 GMT

Hi Subbu,

check the link below .

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-pointers

i hope helps you.

regards

Mahesh T