Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

Case 0002 Why loading time increase 3 time after add section access ?

Hi All

I have a QVW file .

Before i implement section access it only take 8 section to open the QVW file.

After i have implement the section access , i notice that it take 40 second to open the QVW file.

Any idea how to improve the load time ?

Below is my section access script , which is working fine :-

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, SOURCE

ADMIN, QV-PC\QV,*

ADMIN,DESKTOP-9837GT0\pauly,TS
ADMIN,DESKTOP-9837GT0\pauly,TA
ADMIN,DESKTOP-9837GT0\pauly,TP
ADMIN,DESKTOP-9837GT0\pauly,TI
ADMIN,DESKTOP-9837GT0\pauly,SD
ADMIN,DESKTOP-9837GT0\pauly,PM
ADMIN,DESKTOP-9837GT0\pauly,LE
ADMIN,DESKTOP-9837GT0\pauly,PW
ADMIN,DESKTOP-9837GT0\pauly,DA

ADMIN, DESKTOP-8LT09B1\Vincent,TS
ADMIN, DESKTOP-8LT09B1\Vincent,TA
ADMIN, DESKTOP-8LT09B1\Vincent,TP
ADMIN, DESKTOP-8LT09B1\Vincent,TI
ADMIN, DESKTOP-8LT09B1\Vincent,SD
ADMIN, DESKTOP-8LT09B1\Vincent,PM
ADMIN, DESKTOP-8LT09B1\Vincent,LE
ADMIN, DESKTOP-8LT09B1\Vincent,PW

USER, CHOILIN-ACER\chanc,TS
USER, CHOILIN-ACER\chanc,TA
USER, CHOILIN-ACER\chanc,TP
USER, CHOILIN-ACER\chanc,TI

USER, ROGER\Roger Wee,TS
USER, ROGER\Roger Wee,TA
USER, ROGER\Roger Wee,TP
USER, ROGER\Roger Wee,TI

USER, DESKTOP-K8C67RI\aipeng,TS
USER, DESKTOP-K8C67RI\aipeng,TA
USER, DESKTOP-K8C67RI\aipeng,TP
USER, DESKTOP-K8C67RI\aipeng,TI


USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TS
USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TA
USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TP
USER, LAPTOP-0Q70SNQH\Ong Siew Leng,TI


];


SECTION APPLICATION;

Below my table model :-

SLOW OPEN.png

Paul Yeo

1 Solution

Accepted Solutions
2 Replies
Highlighted
Master
Master

Hi Sir

Thank you very much for your sharing.

I notice that both does not offer solution. But it does give me some hope.

Paul Yeo