Which is more efficient: Multiple MySQL tables or one large table?

by

Multiple tables help in the following ways / cases:

(a) if different people are going to be developing applications involving different tables, it makes sense to split them.

(b) If you want to give different kind of authorities to different people for different part of the data collection, it may be more convenient to split them. (Of course, you can look at defining views and giving authorization on them appropriately).

(c) For moving data to different places, especially during development, it may make sense to use tables resulting in smaller file sizes.

(d) Smaller foot print may give comfort while you develop applications on specific data collection of a single entity.

(e) It is a possibility: what you thought as a single value data may turn out to be really multiple values in future. e.g. credit limit is a single value field as of now. But tomorrow, you may decide to change the values as (date from, date to, credit value). Split tables might come handy now.

My vote would be for multiple tables – with data appropriately split.

Good luck.

More Related Contents:

  1. How do I specify unique constraint for multiple columns in MySQL?
  2. Create table variable in MySQL
  3. Mysql: Select rows from a table that are not in another
  4. How to import a CSV file into a MySQL table
  5. Maximum number of records in a MySQL database table
  6. MySQL > Table doesn’t exist. But it does (or it should)
  7. Is there any reason to worry about the column order in a table?
  8. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  9. How to store Emoji Character in MySQL Database
  10. MySQL: Quick breakdown of the types of joins [duplicate]
  11. Any way to select without causing locking in MySQL?
  12. Log all queries in mysql
  13. Truncate all tables in a MySQL database in one command?
  14. Cast from VARCHAR to INT – MySQL
  15. How to convert result table to JSON array in MySQL
  16. MySQL: Select top n max values?
  17. MySQL search in comma list [duplicate]
  18. What is MySQL’s default ON DELETE behavior?
  19. How do I setup ASP.NET MVC 2 with MySQL?
  20. mysql DECLARE WHILE outside stored procedure how?
  21. SELECT query return 1 row from each group
  22. MySql Single Table, Select last 7 days and include empty rows
  23. How can I check MySQL engine type for a specific table?
  24. mysql SQL: specific item to be first and then to sort the rest of the items
  25. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. MySQL GROUP BY age range including null ranges
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment