Qlik Community

Ask a Question

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Talk to Experts Tuesday: Live chat Aug. 24th 10 AM ET: Bring your Qlik Gold Client questions REGISTER TODAY

Best Practice: Loading QVD files

ToniKautto
Employee
Employee

Best Practice: Loading QVD files

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)
Version history
Revision #:
2 of 2
Last update:
‎2021-06-09 10:30 AM
Updated by:
 
Contributors