I am using three different models to store three different INCIDENT data (three different incident typesw with different details). For each of the three models, I can have three models to store INVESTIGATION data, for each of the three, or only one model (Investigation data is similar for all three). I am expecting to have large amount of data gathered in the database. Which is better, three INVESTIGATION models for each INCIDENT or there is not much difference in speed for only one INVESTIGATION model?
Loading

Rijwan AnsariPosted Jul 8, 2021, 6:53 AM
HI,
If all those 3 incidents are having similar data then better to use same table and model. You can add additional column/properties to seperate based on type. Creating 3 different tables or models is kind of redundancy. Then you can filter based on incident type. If there will high volume of data then use stored procedures and views to retrive those data. I would suggest to use single model and table to avoid redunancy.
Regards
Rijwan
Marius VasilePosted Jul 8, 2021, 6:55 AM