topic Re: QVD Size and performance in QlikView

QVD Size and performance

Mon, 21 Jul 2014 10:25:22 GMT

Hello Guys,

I am looking for a suggestion for qvd size and performance.I have two tables and I need to bring these data into qlikview.On joining these two tables causes cross joins and it is correct for my scenario and gives me correct set of data.

Only problem is the size of dataset i got.I got around 1crores of records.So it is better to bring whole data in one qvd or create two qvds(each per table) and join them on at run time.?

Thanks in advance.

Re: QVD Size and performance

Mon, 21 Jul 2014 10:29:30 GMT

Without any details it is hard to say what is best for your load. In general it is best to load both QVDs optimized (no Transformation / where clause) as this is the fastest way to get the data into memory. After this you can Join / transform the tables in memory.

Re: QVD Size and performance

its_anandrjs — Mon, 21 Jul 2014 10:30:06 GMT

Better if you join this QVD and make single QVD from this QVD with cross join as you say and then use this QVD i believe it gives right result to you.

Re: QVD Size and performance

ashfaq_haseeb — Mon, 21 Jul 2014 10:32:39 GMT

It really depends on what you are trying to achieve. If you use join without link then it will create Cartesian product and your table will explode.

I would have kept them differently and use set analysis to do required analysis.

and try to join then with some link if possible.

Regards

ASHFAQ

Re: QVD Size and performance

tresB — Mon, 21 Jul 2014 10:45:22 GMT

Creating one qvd could be a better option. That would improve performance because in the front-end on selection the data search would not require table hopping.

Re: QVD Size and performance

vardhancse — Mon, 21 Jul 2014 10:49:11 GMT

if you think there is huge data.

instead of splitting the QVD, go for splitting the QVW based on some condition some thing like region/quarter.

because if data is more in one single QVD, then the performance in the QVW will impact.

One more advantage is that if the same QVD was being used in another dashboard there will be no much impact for that dashboard.