Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Best Practice: Loading QVD files

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
ToniKautto
Employee
Employee

Best Practice: Loading QVD files

Last Update:

Jun 9, 2021 10:30:04 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 15, 2014 7:04:08 PM

QlikView Data (QVD) file is a optimized file format for storing QlikView data tables. The file has a binary data format that can be loaded directly to computer memory without any processing required, which makes it the fastest way to load data into a QlikView application. This way of directly loading data into memory is referred to as an optimized load. 

In QlikView desktop client this optimized load is indicated by the "Script Execution Progress" dialog showing "qvd optimized" when the QVD file is loaded into memory. 

Script Execution Progress QVD optimized.png

If changes are made to the data or table structure during reload the load will no longer be optimized. In this scenario there is no longer a reference to "qvd optimized" in the 

Script Execution Progress.png

The recommended approach for loading QVD file is to always ensure they are loaded as optimized. If changes are required in the loaded data, then this should be applied through the resident load. This could be done by the principle below, where an optimized load is done to a temporary table which is later dropped. 

TmpTable:
LOAD *
FROM MyDatya.qvd (QVD);

MyTable:
LOAD 
  *, Today() AS TodaysDate
RESIDENT TmpTable;

DROP Table TmpTable;

 

Environment:

QlikView 
Qlik Sense Enterprise on Windows 

Labels (1)
Contributors
Version history
Last update:
‎2021-06-09 10:30 AM
Updated by: