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

[paulyeo11]

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

Paul Yeo

[basav · Accepted solution]

Hi Paul,

https://community.qlik.com/t5/QlikView-App-Development/Is-section-access-caused-a-slow-data-reload/t...

https://community.qlik.com/t5/Qlik-Sense-App-Development/Section-Access-Causing-Slowness-When-Openin...

Please check these posts and see if that helps. 

cheers,

Basav

[paulyeo11]

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