topic Re: DOES island data model hamper perforemance in QlikView https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485826#M181536 <HTML><HEAD></HEAD><BODY><P>Ok!! so if its not possible to link island tables, then what could be done? Creating a master calendar and linking it with evry table.. would that work?</P></BODY></HTML> Thu, 05 Sep 2013 11:12:17 GMT varunjain 2013-09-05T11:12:17Z DOES island data model hamper perforemance https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485824#M181534 <HTML><HEAD></HEAD><BODY><P>I am working on a dashboard and I am almost done with the data model, but due to requirements, all the tables are in island position with no linkage or join. As the data is tremendously huge so i want to avoid joins. would this approach effect th eperformance of my application?</P></BODY></HTML> Thu, 05 Sep 2013 10:48:44 GMT https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485824#M181534 varunjain 2013-09-05T10:48:44Z Re: DOES island data model hamper perforemance https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485825#M181535 <HTML><HEAD></HEAD><BODY><P>Yes, tables as islands mean every calculation is based on a cartesian product of the tables involved. Very expensive.</P></BODY></HTML> Thu, 05 Sep 2013 11:09:18 GMT https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485825#M181535 Gysbert_Wassenaar 2013-09-05T11:09:18Z Re: DOES island data model hamper perforemance https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485826#M181536 <HTML><HEAD></HEAD><BODY><P>Ok!! so if its not possible to link island tables, then what could be done? Creating a master calendar and linking it with evry table.. would that work?</P></BODY></HTML> Thu, 05 Sep 2013 11:12:17 GMT https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485826#M181536 varunjain 2013-09-05T11:12:17Z Re: DOES island data model hamper perforemance https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485827#M181537 <HTML><HEAD></HEAD><BODY><P>No idea. I don't know your data or what result you're trying to achieve. See <A _jive_internal="true" href="https://community.qlik.com/thread/18473">this discussion</A> for some perfomance tips and <A _jive_internal="true" href="https://community.qlik.com/thread/66717">this discussion</A> about master calendars.</P></BODY></HTML> Thu, 05 Sep 2013 11:19:51 GMT https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485827#M181537 Gysbert_Wassenaar 2013-09-05T11:19:51Z Re: DOES island data model hamper perforemance https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485828#M181538 <HTML><HEAD></HEAD><BODY><P>Thanks for you reply Wassenaar. What I want to know if there is a situation wherein you cannot link tables,then what alternatives do we have?</P></BODY></HTML> Thu, 05 Sep 2013 11:24:23 GMT https://community.qlik.com/t5/QlikView/DOES-island-data-model-hamper-perforemance/m-p/485828#M181538 varunjain 2013-09-05T11:24:23Z