topic Re: QVW vs QVD performance at runtime in QlikView

QVW vs QVD performance at runtime

Wed, 04 Mar 2015 14:37:34 GMT

Hello,

Considering I have a standard QVW file (a QlikView Project), but I have a lot of data inside this project, so my project is slowing down when I am looking over the sheets (switch).

Is the QVD format only intended to be quicker for loading data at the project's loading step (before runtime) OR... loading the data from a QVD file will make my project more fast at runtime ?

Thanks

Re: QVW vs QVD performance at runtime

Gabriel — Wed, 04 Mar 2015 15:28:31 GMT

Hi,

My understanding of what you're saying is, your application is slow when you navigate between sheets (correct)?

If that is the case, the problem is not with the QVD (yes you're right, qvd is fast for loading), the problem might potentially be in the calculations taking place in the UI of your application.

A good review of some of the functions and calculate in the objects in UI will do you good and optimised your application.

You might want to move some calculations to scrpt.

Please note, without access to the application, this is my best guess.

Hope this helps

Re: QVW vs QVD performance at runtime

maxgro — Wed, 04 Mar 2015 23:21:37 GMT

qvd format could help you at the load (reload) time

at runtime (user accessing the dashboard/document) qvd does not matter

if you want to know how to optimize your qvw, this is a good starting post

http://community.qlik.com/message/463183#463183