Answer the question
In order to leave comments, you need to log in
Is it correct to split into two tables?
Hello. I have a `tasks` table (MySQL database). It contains fields id, name, type... And 15 parameters like performer, performer_method, performing_interval... And the parameters will be supplemented.
Tell me please, what is the best way: to split the main data about the task and its parameters into two tables or leave everything in one?
Using Yii, this table will store more than 100,000 records and be updated frequently
Answer the question
In order to leave comments, you need to log in
If the relation 1-1 that I would not begin to break into tables. When splitting, it can work even slower if you need to do joins.
Also my additional coding. For example, you split and removed parameters in another table. And then the orderer decided that one of the parameters should be the main one and be shown in the list of tasks. You will either have to merge, which makes no sense, why did you break it then, or transfer this parameter and change the code so that it is now saved in the desired table.
But this is my personal experience. Maybe I'm wrong.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question