Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor II

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
Highlighted
Not applicable

Re: Binary Load Performance

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
Highlighted
Partner
Partner

Re: Binary Load Performance

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

Highlighted
Contributor II

Re: Binary Load Performance

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?)

Highlighted
Partner
Partner

Re: Binary Load Performance

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

Highlighted
Not applicable

Re: Binary Load Performance

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

Highlighted
Contributor II

Re: Binary Load Performance

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?