Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVD PURPOSE

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


10 Replies
luis_pimentel
Partner - Creator III
Partner - Creator III

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,

Not applicable
Author

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

Not applicable
Author

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/

Not applicable
Author

One more advantage :

Incremental Load can be done only by using QVD's

Regards,

Divya

Not applicable
Author

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

Not applicable
Author

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

Anonymous
Not applicable
Author

Hi Fabrice,


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

Kind regards,

Henco

salto
Specialist II
Specialist II

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.

suniljain
Master
Master

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