Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Binary Load Performance

Hi guys,

I want to know the restrictions of the Binary Load. From how many qvws can I load one binnary? If I want to have like structure of detail tables inside a qvw and the from n other qvws load it.

Does it affect the performance of the server, or it has the same impact as load individual qvds???

Thanks a lot!

1 Solution

Accepted Solutions
Not applicable
Author

What happens when you do binary load is that you are copying the Data model itself with all the data. So it will be highly efficient.

You can't compare this to using qvd because if you use qvd you have to design the data model again for those ten other qvws but if you use binary you just copy the already available data model.

Things to note:

  • Only one binary load per QVW possible and it should be the very first line in the script
  • It copies the data model with the data but not the objects created nor the variables

Hope it was useful

Thanks

AJ

View solution in original post

5 Replies
nilesh_gangurde
Partner - Specialist
Partner - Specialist

Hi,

First thing is you cant load multiple qvw's with the binary load.

using binary load you can load a single qvw file.

or if you want to load more data which is not available in the qvw file which you are loading with binary load, then you can load it with QVD files.

and performance will be better in the Binary load than normal QVD load.

-Nilesh

Anonymous
Not applicable
Author

So, I have one qvw with a structure and ten qvws that need that structure. It's ok if all of them load the first one? could it be at the same time? and the memory how will be affected? (better performance that the individual qvds that put together all the structure?)

nilesh_gangurde
Partner - Specialist
Partner - Specialist

if you need the particular structure in multiple qvws then its preferred to load with binary load. its fine if you are loading at the same time. The performance will be better than the Qvd load. If you load data from one qvd in multiple qvws at same time it might  give error.

-Nilesh

Not applicable
Author

What happens when you do binary load is that you are copying the Data model itself with all the data. So it will be highly efficient.

You can't compare this to using qvd because if you use qvd you have to design the data model again for those ten other qvws but if you use binary you just copy the already available data model.

Things to note:

  • Only one binary load per QVW possible and it should be the very first line in the script
  • It copies the data model with the data but not the objects created nor the variables

Hope it was useful

Thanks

AJ

Anonymous
Not applicable
Author

Great!!! so I guess I'll be able to reduce a lot of time!!!

One last thing... when it copies all the structure, the RAM increases for binary loaded in each model??? for the physical server it's like loading the same qvd in memory?