Which is better, one large table or multiple small tables in MySQL?

It’s hard to say whether I prefer one big table or multiple small tables. it depends -

• About the application we are using.
• About database normalization

But there are many key points through which we can say that multiple small tables are Which is fine in this case.

Assuming that many developers want to develop multiple tables, they need to split They are divided into multiple small tables.

Scenarios where you grant permissions to many developers. This permission is for different parts data. In this case, it needs to be split into multiple small tables.

Assuming that we want to move data from different places, we need multiple small surface.

The above is the detailed content of Which is better, one large table or multiple small tables in MySQL?. For more information, please follow other related articles on the PHP Chinese website!