Which one is preferred between a large table or multiple small tables in MySQL?

MySQLMySQLi Database

It is very difficult to say whether to prefer one large table or multiple small tables. It depends −

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

However, there are many key points, through which we can say that multiple small tables are good in that situation.

Suppose many developers are going to develop multiple tables, then there is a need to split them into multiple small tables.

A situation when you are giving authority to many developers. This authority is for different parts of data. In this case, a need arise to split into multiple small tables arise.

Suppose, we are moving data from different places then there is a need for multiple small tables.

Published on 22-Oct-2018 12:51:25