Forum Discussion

KayceVC's avatar
KayceVC
Helper II
7 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    you have circular relationships betwen tables which is causing poor performance.  tryy to avoid it

KayceVC's avatar
KayceVC
Helper II
7 years ago

Thank you for the advice, Natel, but these were some of the first things I did in optimizing this report. Unfortunately, the link to this date table is still causing a problem for me.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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