topic Re: QVD vs QVW user performance in QlikView

QVD vs QVW user performance

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

There are two scenarios

1. A.QVW file -

SELECT * FROM Orders ---around 5 million of records

This file creates a .QVD file and this .QVD file is used in B.QVW file

2. C.QVW file

Same as B.QVW file. But the data is pulled directly from Data Source (same Orders table) instead of .QVD file.

I wanted to know is there any difference (performance wise) between B.QVW file and C.QVW file when user access both of this file

Re: QVD vs QVW user performance

yujiyamane — Fri, 09 Mar 2018 03:46:34 GMT

Theoretically, It should be same performance for user experience as the both qvws should be in same file size. There is only difference for loading data. B.qvw loads much faster.

Re: QVD vs QVW user performance

shilpan — Fri, 09 Mar 2018 04:32:06 GMT

There won't be a major difference from the user experience perspective but if you load QVD in optimized mode then the reload time will be better when you read from QVD instead of loading fields from the relational source.

Re: QVD vs QVW user performance

big_dreams — Fri, 09 Mar 2018 05:18:24 GMT

Hi,

Your scenario 1 is 3 tier architecture

Database -> QVD -> application (QVW)

Your scenario 2 is 2 tier architecture

Database -> application(QVW)

Both architecture used on different scenario like if you want to reduce no of hits on database then 3 tier architecture apply.

Loading data from qvd always work faster than loading data from database.

Regards,