Forum Discussion

kevlarmpowered's avatar
kevlarmpowered
Helper I
7 years ago

How many inactive relationships before unusable?

  How many inactive relationships can you have before you notice a significant performance impact?  I have a table with 260 different date columns.  That means I would have 259 inactive relationship...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

kevlarmpowered,

 

I haven't seen any limitation about this. But you might select Unpivot Columns for those date columns in Query Editor.

  • kevlarmpowered's avatar
    kevlarmpowered
    Helper I
    7 years ago

     

    I unpivoted the columns using SQL, but my DB guys are saying that's not a good idea.  I wanted to double check implications of doing it their way 259 inactive relationships before we had a debate about it.