Forum Discussion

karimabdelrazek's avatar
karimabdelrazek
Frequent Visitor
2 years ago
Solved

Duplicate Tables? Modelling Advice

Hi,

I'm a newbie at this. My data model is becoming very large and very complex. I recently "discovered" duplicating tables. It solves a number of problems for me but not sure if (A) this is good practice or not. (B) does it create problems later on? (C) when should I actually use it.

Just for context, the tables I am looking to duplicate are not very large and are not expected to accumulate an "exorbitant" number of records over time.

Any advice would be highly appreciated!

Thanks!

Karim

Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    karimabdelrazek 

    I am not sure what you mean by duplicating tables in your context. In general, more tables would increase your model size and create performance hits unless you author your measures carefully. When you say complex, it si so general and you need to provide more details and context as to where the complexity exists.


2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    karimabdelrazek 

    I am not sure what you mean by duplicating tables in your context. In general, more tables would increase your model size and create performance hits unless you author your measures carefully. When you say complex, it si so general and you need to provide more details and context as to where the complexity exists.


  • karimabdelrazek's avatar
    karimabdelrazek
    Frequent Visitor
    2 years ago

    Fowmy thank you for your feedback. Believe it or not, your reply has actually prompted me to revisit my data structure and therefore my table structure as well. I did find a few opportunities to further simplify the model and am doing that at the moment. I think copying the data tables was more of a "lazy approach" on my part as opposed to rethinking and optimizing.