Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cpkusuma
Contributor
Contributor

Performance and User Experience

I have created a qvw with over 10 sheets (5 sheets are common among 20 users and 5 sheets are specific for each user) that will be accessed by 20 users (each user has his/her own document license).  I would like to know which option is better when deploying into production server:

Option 1: Have 1 qvw document with Section Access so that when a user login, first 5 sheets has common data across users and last 5 sheets are strictly loaded according to department that I set in the Section Access.

Option 2: Create 20 qvw document that already filtered by each user's department so that each user only can access 1 document specifically created for him/her.

The data will be reloaded every night.

Which of the 2 options above have better server performance and user experience.

Thank you in advance.

Regards,

Kusuma

1 Solution

Accepted Solutions
Mark_Little
Luminary
Luminary

HI,

Option one,

1 - As mentions easier to manage changes. Not updating 20 documents.

2 - Take less server resources, as one document loaded in RAM.

3 - Quicker reload

Mark

View solution in original post

6 Replies
Kushal_Chawda

You can go for Option 1. Which is easy to manage (Sanction Access table).

roger_stone
Creator III
Creator III

Purely from a manageability aspect, option 1 is the obvious way to go. One document to maintain, not 20 (or more, things grow).

maxgro
MVP
MVP

Option 1: manegement is better, experience could be the same, depends on doc size.

I would think at option 2 only when you have a big document (what's big?) and performance problem.

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Why not just use on the sheet that's common to x number of users, use condition show with expression as  QVUser = User1 or User2 ....

Then all users can use the same qvw file but not all users can see all the sheets in the qvw file.

Mark_Little
Luminary
Luminary

HI,

Option one,

1 - As mentions easier to manage changes. Not updating 20 documents.

2 - Take less server resources, as one document loaded in RAM.

3 - Quicker reload

Mark

cpkusuma
Contributor
Contributor
Author

Thank you all for your replies.