D
D
Dmitry Baibukhtin2014-09-04 21:14:08
MySQL
Dmitry Baibukhtin, 2014-09-04 21:14:08

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

1 answer(s)
S
Sergey Romanov, 2014-09-05
@PiloTeZ

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 question

Ask a Question

731 491 924 answers to any question