topic Re: Best Optimization Techniques - Qlikview in QlikView

Best Optimization Techniques - Qlikview

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

Can you please confirm what optimization techniques we shud use for faster processing in Qlikview.

For eg - Store data in QVD rather than pulling it from Database again n again

Thanks

prma7799 — Tue, 04 Jul 2017 11:25:18 GMT

Please check this

passionate — Tue, 04 Jul 2017 12:15:42 GMT

Hi Shivesh,

Along with what PM Suggested.

- Use 4 Teir Architecture (QVD,Transform,Datamodel and mainApp)

- Use incremental load strategy for Qvd load

- Use Log Analyser to check load timings for you load script.

- Once Qlikview application is created you can use Document Analyser to check for redundant columns which are loaded.

Regards,

Pankaj

shiveshsingh — Tue, 04 Jul 2017 12:24:29 GMT

Thanks

shiveshsingh — Tue, 04 Jul 2017 12:24:36 GMT

Thanks