Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QlikView Community,
who has experience with Section Access together with big data?
we use QlikView 11.2 SR3. The App is 1,4 GB and has 60 millions recordsets.
The Publisher makes daily reload and afterwards preload.
The Section Access table will be load from SQL Server.
Ca. 200 users have some different rights. Every user can see his data only. It works fine.
Our Problem: first time load performance. After preload on server every user has to wait ca. 40 sec for load of application. If we disable Section Access is the load time 1 sec only. The caching doesn't work first time because most users have different access rights.
What is the cause of this delay? What can we do?
Please not suggest the solutions "reduce the data" or "split the app". It is not possible.
I'd use "loop and reduce" by User, so each user has access only to his own copy, and no need for section access.
If it's not possible, they'll have to live with 40 sec, I guess...