Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Which one is preferred between a large table or multiple small tables in MySQL?
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.
Updated on: 30-Jul-2019
149 Views
Advertisements