Forum Discussion
Solved
Table relationship causes severe performance drop
I have been working to optimize an existing report in our company. I trimmed the largest table down to around 150k rows by adding a date filter. The total report has 14 tables with 11 of them having ...
KayceVC -
Regarding the snowflaking - There are 3 tables that could be removed and incorporated into their respective dimension tables:
Months -> Dates (can create a M-to-M relationship with Agreement Revenue)
Staff Teams -> Staff
Customer Teams -> Companies
you have circular relationships betwen tables which is causing poor performance. tryy to avoid it
KayceVC -
It's just speculation, but perhaps you're bumping into some memory limit. Relationships are stored in memory.