QVD Optimization

[#1]

Hi QV,

  I have 25 tables in the database, and I simply created qvd's for all the tables.

Now I want to optimize these QVD files. Can anyone suggest me how to optimize the qvd files, and how would I know that weather the qvd's are optimized or not.

Thanks,

Ananth

[alexandros17]

Qvd is said to be optimized if when you reload it you avoid where conditions or if clause on fields ...

[ThornOfCrowns]

Generally, adding fields or anything that causes a field value to be examined will force an unoptimized load.

You will see in the loading window if the load is optimized or not.

[jagannalla]

Hi,

Load the qvd files in without any transformations( i.e. expressions). While loading the qvd file in script you should not include any calculation part or transformation in script. If you include it can be treated as UnOptimized load.

Cheers!!

Jagan

[#5]

Thanks to all for your valuable responses.

So all of you meant to say that, there should be no filtering conditions in the script. Isn't it?

[#6]

Hi,

When you load a QVD optimized, you can read it:

[Colin-Albert]

You can have a single Where Exists clause and the reload will still be optimised.

That said reloading from QVD will still be faster compared to accessing the source database. Check the progress window during the load to see if the loads from QVD are marked as optimised.

[#8]

Thanks a lot Augustin, it was very much helpful.

[ThornOfCrowns]

Yes, that's pretty much it.

Loading your data from a QVD then working on the data afterwards to ensure an optimized load is very much a trade off as to load speed versus RAM footprint. If you have a lot of required data in your QVD, you may want to make that trade or you may want to have an unoptimized load by using a WHERE clause, etc.