Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the purpose of qvd and internal how it is work in qlikview? PLZ TELL ME ANYONE....
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,
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
1) Faster Data Reloading Compare original Data Sources
2)Require less Memory to store
3) useful in incremental load
One more advantage :
Incremental Load can be done only by using QVD's
Regards,
Divya
K THANK YOU but how it is work internally means(internal structure ) of QVD
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
Hi Fabrice,
Will a QVD help to make the application faster? Or is it just reducing the reload time?
Kind regards,
Henco
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.
QVD makes data load faster becasue its native format of QlikView.