topic Re: Loading data from database in QlikView https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59681#M774943 <HTML><HEAD></HEAD><BODY><P>From QlikView's help:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A QVD file holds exactly one data table and consists of three parts:</P><P></P><OL style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><LI>A well formed XML header (in UTF-8 char <BR />set) describing the fields in the table, the layout of the subsequent <BR />information and some other meta-data.</LI><LI>Symbol tables in a byte stuffed format.</LI><LI>Actual table data in a bit-stuffed format.</LI></OL><P></P><P></P><P>It is faster to load data from QVD rather than fetching from DB</P></BODY></HTML> Sun, 06 May 2018 18:00:17 GMT shiveshsingh 2018-05-06T18:00:17Z Loading data from database https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59679#M774940 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Can any one tell me why qlikview takes so much tie to load from database directly as compare to QVDs</P><P></P><P></P><P>Regards</P><P>Manu</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59679#M774940 manu1512 2020-11-25T16:16:04Z Re: Loading data from database https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59680#M774942 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sun, 06 May 2018 08:36:49 GMT https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59680#M774942 gayandilhara 2018-05-06T08:36:49Z Re: Loading data from database https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59681#M774943 <HTML><HEAD></HEAD><BODY><P>From QlikView's help:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">A QVD file holds exactly one data table and consists of three parts:</P><P></P><OL style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><LI>A well formed XML header (in UTF-8 char <BR />set) describing the fields in the table, the layout of the subsequent <BR />information and some other meta-data.</LI><LI>Symbol tables in a byte stuffed format.</LI><LI>Actual table data in a bit-stuffed format.</LI></OL><P></P><P></P><P>It is faster to load data from QVD rather than fetching from DB</P></BODY></HTML> Sun, 06 May 2018 18:00:17 GMT https://community.qlik.com/t5/QlikView/Loading-data-from-database/m-p/59681#M774943 shiveshsingh 2018-05-06T18:00:17Z