Good day. When developing a project, I wondered how best, from the point of view of correctness, to structure the database (MySQL engine MyISAM), namely, to store content in one or several tables?
I will give two examples.
This example is taken from CMF MODx. Its peculiarity is that all content is stored in one table, except for user data, rights, etc. Entities (for example, articles, news, tags ...) are separated by the "context" field. Given the intensity with which news, tags, ... are added (there can be as many entities as you like), you can imagine how quickly the single content storage will swell (the "content" table). I understand that the number of records stored in the table is limited, only by the file system, but still.
The difference from the first example is only in the fact that the "context" field is omitted, and the entities are separated "physically", i.e. according to the tables.
There is a conditional rule, if the fields of the tables are equivalent (the same), then merging several tables into one is welcome.
In favor of the second example, I would consider the possible sharding on specific entities in the future. To disadvantages: it was necessary to complicate the logic for implementing the functionality of displaying thematically similar material for a single article.
Dear Gurus, tell me which of these two solutions is preferable in your opinion?