What’s the most efficient database method to add and query usermeta?

There are lots of examples to store the data in usermeta. But should
this amount of data be stored in the usermeta table?

I don’t see any reason why you should not use the default user meta data table, after-all that is what it is for, regardless of the amount of users/fields.

The user meta function , such as get user meta uses get_metadata with the $meta_type object set to user. http://codex.wordpress.org/Function_Reference/get_metadata

If you want to mess around with new tables you can use the $wpdb class and create a new one, this post covers how, http://codex.wordpress.org/Creating_Tables_with_Plugins .

There is also a plugin called Pods CMS that allows for the creation of custom database tables for content types, but unless you have a specific reason for doing so, just use the built in user meta tables.

Related Posts:

  1. Extend the wp_users table
  2. update_user_meta() does not work
  3. Select Multiple meta_value from WP DB; Single Query
  4. Is it possible to store visitors IPs in wp_postmeta table?
  5. Which is more efficient? Using usermeta, or creating a new MySQL table?
  6. A field with dashes in the slug [closed]
  7. In what part of the WordPress core does the users table and usermeta table get joined?
  8. Modify Database in Multi-Site wp_usermeta table
  9. Best way to tell if a user account is active, using the database only
  10. Using GROUP CONCAT in my-sql query with wp_usermeta table
  11. Is it safe to delete unnecessary user metadata?
  12. How to replicate a user plugin made table value, to this user’s custom meta table value?
  13. WordPress Database Huge wp_usermeta Table
  14. How to Access wp_usermeta Data Immediately After a New User is Created
  15. What can I do when an outside party hacks into my weblog and changes my display name?
  16. Users table missing from Database [closed]
  17. Recovering the table wp_usermeta from users
  18. I cannot find the difference between these wp_capabilities values in wp_usermeta
  19. Buddypress avatar image in database [closed]
  20. Storing user submitted forms [closed]
  21. wp_insert_user not creating account correctly when ID is manually set
  22. Compare User meta_value with Product meta_value
  23. Best Practice? – Saving multiple Values as Serialized Data / Saving each Value per Row / Dedicated Table
  24. Join Query on WP_USERMETA Table
  25. how add more field to wp user and save it to database
  26. Move Non-WordPress users table to WordPress database
  27. generate PDF from member information
  28. How to get the id of recently registered user from database?
  29. update multiple user meta field based on another meta field
  30. get_user_meta and umeta_id
  31. Preventing concurrent update of data
  32. Calling update_user_meta inside of another function doesn’t work
  33. What is best for saving lot of extra detail of user?
  34. wp_usermeta key problem
  35. Query a meta key using an array of values where the database value is a string
  36. MySQL SELECT increment counter
  37. Exclude Statement in SQL
  38. Detecting errors generated by $wpdb->get_results()
  39. wpdb update add current timestamp not working
  40. Displaying content from one WP site on separate WP site
  41. Lost the `wp_options` table: what’s the best way to restore the site?
  42. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  43. How might I retrieve a featured post image from an external WP site and display it as a link back?
  44. What is the database table for pages?
  45. What are conventions about the schema of the $table_prefix
  46. WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
  47. Strange Deadlock database error for the query “Delete From wp_options”
  48. WooCommerce – Query for ordered products
  49. PHP variable in WordPress database query
  50. Differences between add_post_meta and update_post_meta
  51. Is a direct or import approach safer for migration into WordPress?
  52. One post carries 30 postmeta values, is this too much?
  53. Is it possible to split database tables using HyperDB?
  54. What happens if I overwrite the current wp_options table with a backup from a week ago?
  55. Critical error in final stage of website launch – URLs are BROKEN!
  56. How do I get WordPress login to ignore the password input if a particular username is used?
  57. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  58. “Error establishing a database” connection on some sites
  59. How to Mirror WordPress database from Remote server to Local server
  60. WordPress is not creating table in database after activating plugin,
  61. How do I delete these post types in my WordPress database?
  62. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  63. How do I query wp_options for expired transient pairs with MySQL commands?
  64. WordPress running SQL query to update database from form
  65. Use same database on main domain & sub domain
  66. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  67. Why user_pass column in wp_users table is varchar(64)
  68. Why this query is not showing any result on wordpresss home page?
  69. How to migrate a database from a server to another
  70. Reinstalling wordpress from database breaks the site
  71. how to count click tab menu and insert to database
  72. Adding prefix to WordPress database tables breaks admin capabilities?
  73. What is the best way to resurrect and update my old WordPress site?
  74. Trouble running $wpdb->query() with last_insert_id
  75. Using $wpdb | checking entered email against existing emails in db
  76. wp-cli: Error establishing a database connection: undefined constant DB_USER
  77. Get results from wordpress data custom table
  78. Outputting query results
  79. Help With a Large WordPress Based MySQL Database on Shared Hosting
  80. Database migration issues – Error #1046 No database selected
  81. Can two domains use the same database?
  82. Search Character Set Problem
  83. How to fix Uploaded to this post option to see group of images uploaded to a post?
  84. adding user_id and name to a separate table whenever a user register based on role
  85. How to access a table in a wordpress database using REST API?
  86. User saved through WordPress backend does not show up in database table users
  87. Adding featured for post using database
  88. get_the_terms is not working
  89. Store id from database query in cookie
  90. Return image urls with specific base string?
  91. What WordPress file is saving new users to database
  92. Restoring .sql backup results in “Error establishing a database connection”
  93. Link to handle $_GET request
  94. WordPress sync with phpbb
  95. “MySQL server has gone away” since update to 3.8
  96. Getting deleted users in database
  97. Getting data from a table using a query
  98. Database interaction (private-public) [closed]
  99. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  100. WordPress database connection failed, while mysql client is working [closed]

Leave a Comment