update_user_meta: How many is too many?

To answer your questions:

Would these high number of calls to update_user_meta cause any
performance degradation?

The Higher the number of calls to the database the slower its going to work since every query takes some (not much but still) time.

Which of the two appears to be a better solution?

Recently I finished a project with similar amount of user settings and the solution i ended up with was to store as an array all of the data that i didn’t need to query or search based on, (since when using array to store data in the data base it is stored serialized ) and the rest (data that needs to by queried based on) as single rows of data, which cut down the queries on one page from 68 to just 7.

Related Posts:

  1. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  2. Individual Widgets per Page
  3. Is it safe to store a user setting you don’t want the user to ever modify as a user option?
  4. Add custom fields to search
  5. How to add add_meta_box to specific Page Template?
  6. Apply the_content filter to a custom field with multiple values
  7. How to get users by a custom field / by user meta data?
  8. Auto sort the wp-admin post list by a meta key
  9. Adding another state (spam, reject, approve) to wordpress comments?
  10. Allow user to create instances of custom field
  11. Add custom field (value) to search result (without plugin)
  12. How to add a theme custom variable to a post title?
  13. Save HTML formatted data to post meta using add_post_meta()
  14. Check before publishing, if already exist post with current custom field value
  15. Register new user and add custom data row value for it
  16. Create ul list in Custom Meta Box?
  17. Create custom field key upon theme activation
  18. Save attachment custom fields on front end
  19. Display custom field only if value present?
  20. Advice needed for importing custom field data and database structure
  21. How to save multiple metaboxes?
  22. Custom field value based on other custom field values
  23. meta_value_num sort glitch
  24. Populate Custom Field Dropdown on Theme Install?
  25. Make URL in custom field hyper link
  26. Sorting posts by custom fields in meta_query
  27. nextgen gallery: how to get picture url by gallery id
  28. meta_query for a string inside a meta field containing a comma-separated list
  29. Combine multiple custom field values into single value
  30. Creating a custom menu/widget area
  31. How to add posts through CSV or excel file in a PHP file
  32. Modifying custom order item meta from admin order view
  33. Let users track progress by entering a number daily in profile?
  34. WooCommerce – Adding Custom Fields To Invoice
  35. Can’t display errors in attachment_fields_to_save
  36. $form_fields from attachment_fields_to_edit returning empty array
  37. How to link keywords in custom fields?
  38. Customizing WP user profile with custom fields
  39. Custom Field 101
  40. When creating a metabox do you have to create DB fields for the data?
  41. Adding custom field to post object from custom table
  42. Using abs() with custom field in orderby statement
  43. Can’t save custom field on registration page
  44. Best filter to use for modifying custom fields on a post?
  45. How do I query the title (or handle?) of post meta fieldset (created with Simple Fields Plugin)
  46. Is it preferable to use custom code to create metaboxes instead of plugins (such as ACF) and if so why? [closed]
  47. Function that replaces the image in the absence of the post meta
  48. check for duplicate user meta data before updating
  49. Is there a way to set default custom fields when creating a new post?
  50. WP Cli – post add meta in xargs after wp post generate – add multiple fields
  51. Anyone know how to use ACF and show custom fields for logged in users only on a post? [closed]
  52. How to redirect to home page according to a specific page custom fields value and user name
  53. Add custom column for custom field
  54. ul list with only as many li’s as filled custom fields
  55. Is there a way to dump all registered sidebar/widget?
  56. How to hide post meta
  57. ACF Plugin How to make the customer add more fields in the post?
  58. custom field in admin columns
  59. Custom metabox not working
  60. Meta Box Plugin Cloned Fields – Multiple Foreach values
  61. get_post_meta returns 0
  62. Populate wordpress menu with link to custom field value (file download)
  63. Selectively hiding or allowing thumbnails of featured images on front page
  64. Custom field bug in WordPress 3.2
  65. Users uploaded image and matching an id or taxonomy
  66. Adding data to User profile
  67. How can I change author of posts to the value of one of the custom field of the posts?
  68. Let any visitors delete a post if they know Id nr & password?
  69. Is it possible to add Term Meta Fields to a WooCommerce Attribute?
  70. update a custom field with the value of another existing custom field
  71. Post meta data not showing in frontend, until hitting ‘update’ button
  72. Ordering posts by custom fields (Date)
  73. register_form, custom field not submitted on first try
  74. PHP and Shortcode Combination
  75. Retrieving Advanced Custom Field within Shortcode Function [closed]
  76. How to properly get popular Posts by multiple Values
  77. Echo out custom fields in comments
  78. Query Custom Fields in Searchform
  79. Make custom user_meta as permalink for post
  80. Creating Structured Documents (books) in WordPress?
  81. Filter query based on date in custom field
  82. Get custom fields when hover link of post
  83. WP Query multiple select form – meta_query help
  84. update_post_meta not working in action hook
  85. Group pages by custom field values
  86. Convert many posts from having a specific meta_key to use a post_format
  87. Custom fields: my custom checkbox area doesn’t seem to work
  88. get_post_custom_values not working
  89. How to create Parent-Child relation for custom fields?
  90. How to check if custom field exists in this widget query
  91. display loop only if a post meta data exist
  92. How do i output images from URL’s added to the same custom field key
  93. Add Custom field under the post title [closed]
  94. Check if a field is capitalized?
  95. Filter Query Post by Custom Fields(by date)
  96. Can’t sort custom column on user.php by number / meta_value_num?
  97. Need to call this php function inside a modal window from text widget
  98. add multiple values (array) to post meta_input
  99. Assign class to Drop Down Selections in WooCommerce Products Custom Fields
  100. Conditional display based on ACF checkbox

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduseduedusedueduedueduseduedus