Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dimitri_obrant
Contributor

Section Access with big data

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.   

1 Reply
mov
Esteemed Contributor III

Re: Section Access with big data

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...

Community Browser