QVD vs QVW user performance

[Anonymous]

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

[yujiyamane]

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.

[shilpan]

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.

[big_dreams]

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,