topic Re: Performance - Load facts and dimensions separately or through one &quot;big table&quot;? in QlikView https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497378#M1134016 <HTML><HEAD></HEAD><BODY><P>Hi Adam.</P><P></P><P>I suggest you read this blog post <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join</A></P><P></P><P>BR</P><P>Ida</P></BODY></HTML> Fri, 08 Nov 2013 10:30:11 GMT 2013-11-08T10:30:11Z Performance - Load facts and dimensions separately or through one "big table"? https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497377#M1134015 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>with colleagues we discussed what is better performing load or qvw document. Statements:</P><P></P><P>Generally, for the performance is better</P><P>A) to load lots of tables separately and let QV to join them</P><P>B) join everything in DB and load the view as one big table, because I prefer handling this in DB</P><P></P><P>I belive, it doesn't matter. Maybe for loading data is A) more appropriate, but for document performance it makes no difference.</P><P>What is correct?</P><P></P><P>Thanks, Adam</P></BODY></HTML> Fri, 08 Nov 2013 10:25:37 GMT https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497377#M1134015 adam1988 2013-11-08T10:25:37Z Re: Performance - Load facts and dimensions separately or through one "big table"? https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497378#M1134016 <HTML><HEAD></HEAD><BODY><P>Hi Adam.</P><P></P><P>I suggest you read this blog post <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join">http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join</A></P><P></P><P>BR</P><P>Ida</P></BODY></HTML> Fri, 08 Nov 2013 10:30:11 GMT https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497378#M1134016 2013-11-08T10:30:11Z Re: Performance - Load facts and dimensions separately or through one "big table"? https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497379#M1134017 <HTML><HEAD></HEAD><BODY><P>If its the first time, you should try both, I feel.</P><P>If you load a very big table, the reload time will be huge, but, you can predict the</P><P>behaviour of various objects.</P><P>If you reload a number of tables, you can make use of associative nature of qlikview and</P><P>show valuable information.</P><P>It really depends on your requirement.</P></BODY></HTML> Fri, 08 Nov 2013 10:37:25 GMT https://community.qlik.com/t5/QlikView/Performance-Load-facts-and-dimensions-separately-or-through-one/m-p/497379#M1134017 2013-11-08T10:37:25Z