What is the advantage of separating wp_users and wp_usermeta table?

The meta table is build to allow custom user meta. If anything would be in just one table a plugin developer had to add a new column to the table for each meta data or the data had to be stored as serialized arrays/objects which would made them unsearchable.

Short: Performance and flexibility.

Related Posts:

  1. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  2. phpMyAdmin – Error > Incorrect format parameter?
  3. Why is my database import losing text widget data?
  4. Get error messages when $wpdb->insert() returns false?
  5. Does dbDelta delete columns as well?
  6. Insert data in database using form
  7. When is it appropriate to create a new table in the WordPress database?
  8. Special characters in WordPress UTF-8 [closed]
  9. Why does dbDelta() not catch MysqlErrors?
  10. Accessing two databases
  11. how to transfer wordpress sql/database from local to live
  12. Is altering a default WordPress database table update safe?
  13. Copy customizer options to child theme
  14. what to do when your WordPress database is too large?
  15. Change all http to https in mysql databse?
  16. WordPress DB: options-table –> 32 gzipcompression?
  17. Having issues with wp_postmeta and wp_usermeta tables too big
  18. How to prevent WordPress from retrieving data for the last 10 posts in the database?
  19. error establishing a database connection
  20. Get data from database using $WPDB
  21. Getting all the users who have author privilege
  22. Uppercase to sentence case for post titles
  23. How to retrieve and show database table in wordpress dashboard
  24. Moving to another host; which tables to move in a database
  25. WordPress mysql table double prefixes
  26. How can I transition a site from using the Beta Tester plugin to a “normal” install?
  27. SQL Query to Update Admin Email
  28. Storing data for a wordpress plugin
  29. Transient feeds and caching error
  30. get_tags() return an empty array after added tags with wp_insert_term()
  31. Is it a bad idea to write audit/access/transaction log information directly to the filesystem?
  32. WordPress database import: Row size too large
  33. Advanced SELECT query with condtional statements
  34. Why do mass updates to post_content shows in front end, but not in edit screen?
  35. How to disable (get rid of) home page main loop entirely?
  36. Insert post in another database
  37. Sync user meta data to a second database
  38. Redirecting to old domain after migration website
  39. WordPress Database Huge wp_usermeta Table
  40. wp-cli search is returning ‘search’ is not a registered subcommand of ‘db’
  41. Localhost keeps redirecting to live domain
  42. How to get membershiplevel from WordPress Database?
  43. cache specific data?
  44. Child parent relationship inside WP DB
  45. Copying database tables to new database
  46. Duplicating Complete WordPress Install for Development and then Redeployment?
  47. I have a 1300 line excel spreadsheet that needs to get into a wordpress site ASAP – Looking for ideas
  48. What does wp_term_taxonomy.parent reference?
  49. How to combine multiple wp_insert_post into one in order to gain better performance
  50. How to get nav_menu_item_id and slug from wp database
  51. Two prefixes in database? Which one is valid?
  52. Enter user registration information in the database
  53. Problem in using wpdb
  54. How can I restrict php mail() to only send me one email after a db error
  55. pull data from a remote wordpress database
  56. Create database on installation
  57. Importer fails to import every post
  58. How to delete post comments from the database via SQL statement?
  59. Users table missing from Database [closed]
  60. Why does changing Database Table Prefixes result in loss of content?
  61. Options on how to Display member specific data from a MS SQL database
  62. How to connect and insert data in database of wordpress?
  63. Unkown meta_value in ACF
  64. Buddypress avatar image in database [closed]
  65. wp_option table error while importing
  66. wp_insert_user not creating account correctly when ID is manually set
  67. Installing local to live WP into subdirectory
  68. WordPress SQL – How to Check for Category?
  69. What is wrong here? Issue with post_id and meta_value
  70. Getting WordPress to work inside a rails 3 application
  71. MSQL database wp_postmeta has meta key tve_revision
  72. Occasional Error Establishing a Database Connection
  73. WP 5.5, child themes, customizer and a weird cache issue
  74. Display user data in numbered list
  75. Removing old_slug and old_date from WordPress Database
  76. Help with $wpdb on custom code
  77. “BS_” rows in postmeta table
  78. How do I change several broken URLs in a several wordpress databases in the fastest way?
  79. Best way to store 1 billion+ posts?
  80. Optimize WP site for millions of posts
  81. Duplicate database to roll back theme & content changes
  82. Character encoding issue – black diamond question marks on imported post excerpts
  83. WordPress Migration – Issue with admin panel changes
  84. mySQL database size large, but tables size less
  85. Reinstall wordpress/mySQL caused database problem
  86. How To connect to the same WordPress database with different database user
  87. How much post meta data is too much?
  88. I have include wp-config, should I add global $wpdb also?
  89. Localize strings from db
  90. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  91. How to have WP Search widget index dynamically generated content?
  92. Preventing concurrent update of data
  93. Redirect Issue: WordPress database
  94. Category not displaying in add post, edit post, and categories page.
  95. Creating Job Tickets
  96. $wpdb->prepare returns empty array
  97. Prevent creation of unused database tables?
  98. How to store a plain password in WordPress database in another field
  99. How to stop WordPress from using utf8mb4_unicode_ci collation
  100. WordPress database connection failed, while mysql client is working [closed]

Leave a Comment