Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

Which one gives better peformance for large data set . 

Link Table with multiple fact tables

One concatenated fact table with multiple columns

Also i have observed that the second option increases the size of qvw application . is it fine ???

6 Replies
Not applicable

Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

please refer Concatenate vs Link Table by amz

Not applicable

Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

Ankur i have read that pdf .

Just wanted to understand from people in community from their real time experience in their respective project on this scenario.

Not applicable

Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

I have used second option in my project and found slight lag while reloading the data

Not applicable

Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

What about the performance of your dashboard . I have also used the second option and found it improving the performance of dashboard but the file size increased by way too much

Not applicable

Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

File size was a concern for me too.. it increased drastically.. However performance was slightly improved

Not applicable

Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns

Only concern for me was the file size and reload time