topic Re: binary load vs load from qvd in QlikView

binary load vs load from qvd

Wed, 24 Sep 2014 12:47:44 GMT

Hi everybody

I have a flat table stored in a qvw application , and the same table stored into a QVD file.

Now i have to read this table from a new application, Which is the better ( or faster ), between

Binary TableName.qvw

and

load * from TableName.qvd

The table has 3 millions of record, in my performance test they seem quite similar.

thank you very much

Re: binary load vs load from qvd

Gysbert_Wassenaar — Wed, 24 Sep 2014 12:58:23 GMT

They would be quite similar in performance since they both basically do the same thing: load a binary dump of data in the format it will have in Qliks internal in-memory database (in ram memory). The difference is that a binary load will load all the data from a qvw file, but from one qvw file only, while a qvd file can contain only one table and you can load from as many qvd's as necessary.

Re: binary load vs load from qvd

sudeepkm — Wed, 24 Sep 2014 13:06:13 GMT

Binary Load:

you can only use one binary load. that means you can load from one qvw at once.

you can load a complete data model along with data into your qvw using binary load

you have an option to prohibit it while using Section Access

binary load QVWs are useful for Data model or Data mart. Many Visualization Dashboards can be created based on one QVW Data model which can be binary loaded into multple qvws

QVD:

QVD holds just one table's data.

you can load from multiple QVDs.

QVDs are useful for staging data stores

Re: binary load vs load from qvd

Wed, 24 Sep 2014 13:17:52 GMT

OK guys, thank you very much, your answers are very weel