Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More

QlikTip#: Keep Optimized QVD Load

Not applicable

QlikTip#: Keep Optimized QVD Load

Generally, QVD's are one of the most important in any Qlikview deployment.

A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. QVD is a native QlikView format and can only be written to and read by QlikView. The file format is optimized for speed when reading data from a QlikView script but it is still very compact. Reading data from a QVD file is typically 10-100 times faster than reading from other data sources.

Whenever we are are using to QVD as data source, we need to keep the Optimized load better reload times. But in some cases we didn't keep optimized loads especially if we are using filters with Where command.

Other hand , we can keep optimized loads in some scenarios:

LOAD * FROM QVDANAME.qvd (qvd) Where Match(REGION_NAME,'US','CANADA');

In the above case, we are loading the data only from US and CANADA region and this is unoptimized load. But we can load as Optimized load by using EXISTS key word with temp table.

First, create the Temp table with filters and use EXISTS key word in main QVD loading statement like below:

TEMP:

LOAD * INLINE [

REGION_NAME

US

CANADA ];

LOAD * FROM QVDANAME.qvd (qvd) Where EXISTS (REGION_NAME) ;

DROP Table TEMP ;

Note: Please make sure that TEMP having the same field name which QVD have

Comments
Not applicable

Thanks for sharing.

But there are some other applications which can read QVDs.

You would have included more information on QVD Load

      - Increasing Load Speed

      - Decreasing Load on Database Servers

      - Consolidating Data from Multiple QlikView Applications

      - Incremental Load

Not applicable

Thanks for your Input Nagaraj ....

0 Likes
MVP & Luminary
MVP & Luminary

Many thanks for sharing this.  You may also like to see my blog post on Optimised QVD load:

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Steve

0 Likes
Not applicable

Thanks Steve.

NavinReddy
Contributor II

Thanks for sharing.Nice post.............

0 Likes
anjeepvr
Contributor II

Even i thought of this approach to make the load as optimized by creating one TEMP table .

Thanks for sharing Srikanth .

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2014-01-17 09:08 PM
Updated by: