Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
varunjain
Creator
Creator

DOES island data model hamper perforemance

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?

4 Replies
Gysbert_Wassenaar

Yes, tables as islands mean every calculation is based on a cartesian product of the tables involved. Very expensive.


talk is cheap, supply exceeds demand
varunjain
Creator
Creator
Author

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?

Gysbert_Wassenaar

No idea. I don't know your data or what result you're trying to achieve. See this discussion for some perfomance tips and this discussion about master calendars.


talk is cheap, supply exceeds demand
varunjain
Creator
Creator
Author

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?