binary load vs load from qvd

[#1]

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

[Gysbert_Wassenaar]

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.

[sudeepkm]

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

[#4]

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