topic Re: Binary Load Performance in QlikView

Binary Load Performance

Anonymous — Wed, 15 Jan 2014 19:13:22 GMT

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!

Re: Binary Load Performance

nilesh_gangurde — Wed, 15 Jan 2014 19:24:55 GMT

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

Re: Binary Load Performance

Anonymous — Wed, 15 Jan 2014 19:27:40 GMT

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

Re: Binary Load Performance

nilesh_gangurde — Wed, 15 Jan 2014 19:33:26 GMT

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

Re: Binary Load Performance

Wed, 15 Jan 2014 19:45:00 GMT

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

Re: Binary Load Performance

Anonymous — Wed, 15 Jan 2014 19:58:00 GMT

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?