Database efficiency – table per user vs. table of users

by

The database layout should not change when you add more data to it, so the user data should definitely be in one table.

Also:

  • Having multiple tables means that you have to create queries dynamically.

  • The cached query plan for one table won’t be used for any other of the tables.

  • Having a lot of data in one table doesn’t affect performance much, but having a lot of tables does.

  • If you want to add an index to the table to make queries faster, it’s a lot easier to do on a single table.

More Related Contents:

  1. What are the options for storing hierarchical data in a relational database?
  2. Is there any rule of thumb to construct SQL query from a human-readable description?
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. In MySQL queries, why use join instead of where?
  5. Doing a WHERE .. IN subquery in Doctrine 2
  6. Transpose latest rows per user to columns
  7. Is there any boolean type in Oracle databases?
  8. A beginner’s guide to SQL database design [closed]
  9. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  10. SQLite – ORDER BY RAND()
  11. The Next-gen Databases [closed]
  12. SQL Between clause with strings columns
  13. Insert an image in postgresql database
  14. Do database transactions prevent race conditions?
  15. Database EAV Pros/Cons and Alternatives
  16. How can I do a BEFORE UPDATED trigger with sql server?
  17. Conditional logic in PostDeployment.sql script using SQLCMD
  18. Is there a difference between Select * and Select [list each col] [duplicate]
  19. Does an empty SQL table have a superkey? Does every SQL table have one?
  20. How to sum up time field in SQL Server
  21. Can SQL Server Express LocalDB be connected to remotely?
  22. What can cause an Oracle ROWID to change?
  23. SQL: Using NULL values vs. default values
  24. Why don’t DBMS’s support ASSERTION
  25. Upsert with a transaction
  26. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  27. Relational Data Model for Double-Entry Accounting
  28. Creating a custom ODBC driver
  29. Do conditional INSERT with SQL?
  30. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?

Leave a Comment