Loading data from database

[manu1512]

Hi all,

Can any one tell me why qlikview takes so much tie to load from database directly as compare to QVDs

Regards

Manu

[gayandilhara]

QVDs are Qlikview native data formats which definitely is the recommended way of loading data especially if the volumes are large. You might need to consider the volume of records as sometimes it may not make practical sense to have QVDs for all forms of data. If you're talking about millions of records, then QVDs will definitely be the best approach.

[shiveshsingh]

From QlikView's help:

A QVD file holds exactly one data table and consists of three parts:

1. A well formed XML header (in UTF-8 char
   set) describing the fields in the table, the layout of the subsequent
   information and some other meta-data.
2. Symbol tables in a byte stuffed format.
3. Actual table data in a bit-stuffed format.

It is faster to load data from QVD rather than fetching from DB