How do you optimize QlikView Application?

For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization I believe not use any tools we can manually remove unwanted fields form data model or comment it, remove most complex logics from the load script or create it with the simple way because it will take long time for loading. If using large data base file try to create the incremental load for the QVD or load latest data only.

What are the restrictions of Binary Load?

Binary load is used only for one application means you are able to read data from only one QVW application and on the above of the set scripts is a restriction. In QlikView data is stored in QVDs but if you are using any QVW application data is loaded in the RAM that’s why it is called as In-Memory analysis tool.

Briefly explain how does QlikView storage the data internally?

QlikView store data in to QVD. QVD have data compression capability. QlikView have better performance compared to other BI because of in memory analytics approach, in built ETL handling capability.