Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Optimization QVD's

Hi Experts,

I have one question for optimization level..

Database team has created one table for 50 countries data. (should I create single QVD or country wise QVD's)

and I have many aggregate tables apply to main table.

which one is the best practice ?

 

1 Reply
zwilson_borg
Contributor III
Contributor III

I tend to work QVDs that match my end data model so that 1 QVD matches 1 table. If you're planning to load all the countries every time you load your dashboards, then a single QVD makes sense.

Subsetting makes more sense if you're sharing QVD across many dashboards, and each dashboard typically needs a subset. In this scenario, you'd rather not load the entire set and then filter down, but rather load the subset.