Best Optimization Techniques - Qlikview

[shiveshsingh]

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]

Please check this

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

Performance and Optimization Best Practices in QlikView & Qlik Sense

[passionate · Accepted solution]

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]

Thanks

[shiveshsingh]

Thanks