Best db table structure for users with many records

Personaly I would go with one table for all users. Having more tables with the same columns seems like a strange idea to me. The database will be a complete mess after you gwt more users.

Make sure that the user_id is an index for the table and all your select/update/delete will be fine. The insert might have a very short but unsignificant delay after the table gets bigger, but I guess this might not be the most used opperation.

Related Posts:

  1. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  2. Oracle SQL query for Date format
  3. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  4. Can I have multiple primary keys in a single table?
  5. get_results using wpdb
  6. Database connection close
  7. How to create bulk page and content? [closed]
  8. Importing posts from old website to new conflicting post ID’s?
  9. Exporting revisions
  10. Transient RSS feeds in wp_options not removed automatically?
  11. Best way to move live site local
  12. The revisions table in my database is at 70% capacity and growing. What should I do?
  13. WordPress for a very large website
  14. How to use multiple database in wordpress?
  15. Database location in WordPress
  16. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  17. WP_list_table bulk_action get edit and delete
  18. How to display data from custom table in wordpress database?
  19. Is removing orphaned wp_postmeta records safe?
  20. Change SQL get_results to search for posts with custom term in custom taxonomy
  21. How to diagnose and keep in check encoding issues?
  22. Add search Value to wp_list_table pagination
  23. stdObject stored in database. How does one convert it to usable format?
  24. I have a table I created, how do I make a form for a user to filter the data?
  25. What ALL can cause “Another update is currently in progress.”? [closed]
  26. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  27. Trigger Plugin database update after git pull
  28. Does WordPress ever need multiple databases?
  29. Why are no posts showing despite my apparently correct DB restoration?
  30. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  31. Cannot update custom database table row
  32. SQL Error wp_commentmeta – incorrect table definition
  33. Change WordPress prefix for only one table?
  34. Two websites one database, administrator not working on second website
  35. Multiple wp_options tables to share content across installs
  36. Select two sums with single get_var statement
  37. How to get the SQL of the changes made to the database from an update or upgrade?
  38. How can i add custom fields into the contact form 7 [closed]
  39. Is there a smart way to obtain a list of only some selected user meta data?
  40. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  41. Permit Login if table row exists
  42. Make an Items attribute searchable (taxonomy using existing attribute)
  43. What would Repair and Optimize WordPress Database do?
  44. Store partial database to an archive database time to time
  45. Saving zero as meta value
  46. Migration: Copying database content to a different server
  47. Remove empty rows from the database
  48. Check if post id exist in table than only update instead of inserting new row
  49. Detail explanation of wordpress database fields and metatag list [closed]
  50. CreateOrUpdate in WordPress
  51. How to convert srcset links from https to http?
  52. How to get a list of WordPress default database tables?
  53. How to transfer from localHost to live but use the already existing database on the server?
  54. Backing up WordPress database and files
  55. Creating and Using Tables in the WordPress Database
  56. Connect a membership plugin to an external database
  57. Compare User meta_value with Product meta_value
  58. Storing user’s data on external database on other server
  59. is it right choose to connect database in template page directly in WordPress site?
  60. How to insert a value to decimal type field using wpdb->prepare?
  61. Sql query to get all metadata for a post
  62. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  63. Set a cron job to delete a specific database table table every midnight
  64. Two separate wordpress installations at one domain
  65. Is there a way to edit the WP content database in an admin panel or external page?
  66. Where do I put my create_new_table function()?
  67. SQL database import #1046 error
  68. Get all top categories, then only 3 posts for each
  69. Having all “non-PHP” files on a different server
  70. syntax error for changing user role from database
  71. Where is the HTML-handler part in the wpdb class?
  72. Finding a page holding a specific string/URL that is used in the content
  73. “wordpress error in establishing database connection” and missing tables
  74. get_option() does unserialize and don’t remove \
  75. next comment id number wordpress
  76. Adding last value from Database as text in WordPress Page
  77. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  78. Merging development site with live site
  79. Backup Restore turns carriage returns to literal strings
  80. I have a WordPress 4.6 database dump – how do I use it in a new install?
  81. Find/ascertain latest wordpress db from multiple database copies
  82. Local Content different from Remote Content
  83. Check if a database is well installed
  84. Checking if the data already exsis in the wp database – custom plugin
  85. live site do not update after importing sql database
  86. Transforming an wp_options database array into a javascript obect?
  87. WordPress + Postgresql
  88. How can I retrieve data from alternate database using wpdb class?
  89. Author ID mismatch from database
  90. MySQL Database User: Which Privileges are needed?
  91. Import Excel (or csv) Table with user-data as subscribers to wordpress
  92. Automatic add record after refreshing page
  93. User accounts for saving form data?
  94. Trying to edit a WP site locally using MAMP
  95. SQL query : Select a thumbnail for a media
  96. WordPress: Interact with Database Query Data and Login
  97. Attach posts based on category and position
  98. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  99. WP Multisite Users Not Linking
  100. Query a meta key using an array of values where the database value is a string
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)