topic Re: Qlikview security causing long reload time in QlikView

Qlikview security causing long reload time

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I have a Qlikview app with a security load in as well.

If I put the security load at the end of the script, the app builds in half an hour.

If I put the security at the very beginning of the app, the app loads in 3 hours.

what could be causing this? The security load takes like 1 second.

thanks,

Stefan

Re: Qlikview security causing long reload time

varshavig12 — Fri, 04 Nov 2016 11:38:47 GMT

Security load... Do you mean section access ?

Re: Qlikview security causing long reload time

Anonymous — Fri, 04 Nov 2016 11:47:54 GMT

that is correct

Re: Qlikview security causing long reload time

DavidFoster1 — Fri, 04 Nov 2016 11:53:04 GMT

Section Access has to be the first code (only Binary load can be before) in the app before any data is loaded.

Putting it at the end means that it is ignored.

It is interesting that it had such a big impact on load times. Are there a lot of security filters?

Re: Qlikview security causing long reload time

varshavig12 — Fri, 04 Nov 2016 11:59:56 GMT

I'm not very sure,

But, what you can try is,

Create a new qvw of section access and then binary load it in your main qvw.

Note: I have never done this, but you can try

Re: Qlikview security causing long reload time

stigchel — Fri, 04 Nov 2016 12:18:09 GMT

Like said above, the section access part has to be loaded first. The fact that this adds so much load time suggests to me that there are probably some synthetic keys being created between the access table and the application. These won't show in your table view as they are hidden. If you are linking on multiple fields, consider using composite keys. You can test your data model between access and application by commenting your section access statements to load the access table as a 'normal' table so you can look at the data model.

Re: Qlikview security causing long reload time

MK9885 — Fri, 04 Nov 2016 13:02:28 GMT

The best way to avoid load time is to create another qvw as source file and do the binary load for your Data Model. And add your Section Access script after the binary load in source file.

Thanks.

Re: Qlikview security causing long reload time

cwolf — Fri, 04 Nov 2016 13:26:50 GMT

Sorry, but it does not matter where the Section Access is loaded. You can do it at first, at last or in the middle of a script. It's only important that it starts with a "SECTION Access;" and ends with a "SECTION Application;". Normally, there are no problems.

Maybe you have forgott the line "SECTION Application;" after your section access load?

Re: Qlikview security causing long reload time

MK9885 — Fri, 04 Nov 2016 13:38:04 GMT

I agree, it actually doesn't matter where SA script is placed.

Re: Qlikview security causing long reload time

jonathandienst — Fri, 04 Nov 2016 13:51:05 GMT

I agree with Christian. There is no requirement to perform section access first. Its usually one of the last steps in the load script in most of my applications. Indeed, if you want to use generic keys in your section access, you can only build these keys after loading the model.

The only reason for loading SA first would be if you want to place it in the hidden script tab.

Re: Qlikview security causing long reload time

stigchel — Fri, 04 Nov 2016 14:06:32 GMT

Hi Jonathan,

Interesting, like David I thought it had to be first. I wonder where that came from..

If so, why would there be a difference in load time?

Re: Qlikview security causing long reload time

cwolf — Fri, 04 Nov 2016 14:13:19 GMT

There is definitely a logical error in the script. But without knowing the script, the question can not be answered.