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

paulyeo11 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

paulyeo11 — Tue, 30 Jun 2020 07:05:53 GMT

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

topic Re: Case 0002 Why loading time increase 3 time after add section access ? in QlikView

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

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

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