topic Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns in QlikView https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943662#M325202 <HTML><HEAD></HEAD><BODY><P>Ankur i have read that pdf . </P><P></P><P>Just wanted to understand from people in community from their real time experience in their respective project on this scenario.</P></BODY></HTML> Fri, 09 Oct 2015 09:41:01 GMT 2015-10-09T09:41:01Z Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943660#M325200 <HTML><HEAD></HEAD><BODY><P>Which one gives better peformance for large data set .&nbsp; </P><P></P><P></P><P>Link Table with multiple fact tables </P><P></P><P>One concatenated fact table with multiple columns</P><P></P><P>Also i have observed that the second option increases the size of qvw application . is it fine ???</P></BODY></HTML> Fri, 09 Oct 2015 09:33:12 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943660#M325200 2015-10-09T09:33:12Z Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943661#M325201 <HTML><HEAD></HEAD><BODY><P>please refer <A href="https://community.qlik.com/qlik-blogpost/3119">Concatenate vs Link Table</A> by <A href="https://community.qlik.com/people/amz">amz</A></P></BODY></HTML> Fri, 09 Oct 2015 09:38:14 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943661#M325201 2015-10-09T09:38:14Z Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943662#M325202 <HTML><HEAD></HEAD><BODY><P>Ankur i have read that pdf . </P><P></P><P>Just wanted to understand from people in community from their real time experience in their respective project on this scenario.</P></BODY></HTML> Fri, 09 Oct 2015 09:41:01 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943662#M325202 2015-10-09T09:41:01Z Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943663#M325203 <HTML><HEAD></HEAD><BODY><P>I have used second option in my project and found slight lag while reloading the data</P></BODY></HTML> Fri, 09 Oct 2015 09:46:43 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943663#M325203 2015-10-09T09:46:43Z Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943664#M325204 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Fri, 09 Oct 2015 10:07:21 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943664#M325204 2015-10-09T10:07:21Z Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943665#M325205 <HTML><HEAD></HEAD><BODY><P>File size was a concern for me too.. it increased drastically.. However performance was slightly improved</P></BODY></HTML> Fri, 09 Oct 2015 10:19:29 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943665#M325205 2015-10-09T10:19:29Z Re: Which one gives better peformance for large data set - Link Table with multiple fact tables or one concatenated fact table with multiple columns https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943666#M325206 <HTML><HEAD></HEAD><BODY><P>Only concern for me was the file size and reload time</P></BODY></HTML> Fri, 09 Oct 2015 10:20:22 GMT https://community.qlik.com/t5/QlikView/Which-one-gives-better-peformance-for-large-data-set-Link-Table/m-p/943666#M325206 2015-10-09T10:20:22Z