Right way of storing large number of custom post fields

You could encode them as JSON, or as serialized strings (the latter of which you can do using functions already baked in to WordPress). Both of these options will let you keep the number of database rows down.

However, both of these options will also significantly hamper your ability to search the data, or deal with it meaningfully in other ways if you need to in the future.

It does not matter if you have a large number of rows in your database.

If your site gets to the size where that would be a problem, then your hardware will need to grow accordingly. You will put much more load on your server by processing encoded data (or doing esoteric queries to get the data) in one row than you would if the custom fields were all in their own rows.

WordPress can handle a lot of data – let it 🙂

Related Posts:

  1. Custom post type or just use custom fields
  2. Using posts and postmeta table to store custom Address Book Plugin data
  3. WP All Import – Using Xpath to set a select value
  4. Sorting custom post type columns with external data and without meta values
  5. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  6. Importing Data from a Non-WordPress database, into WP
  7. Specifying meta field’s column type in Database using add_post_meta
  8. Ideas to connect external database table to wordpress posts as custom field source
  9. delete duplicate meta_value with same post_id
  10. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  11. when looping through custom post data not appearing
  12. custom post types, custom fields and normalization
  13. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  14. Confused about where to store my data
  15. Populate custom post type/custom fields from an external database
  16. Automatically convert standard posts with custom fields to custom post types
  17. How to enable the user to add value through the admin panel?
  18. Displaying database table in backend of wordpress
  19. Querying Two Custom Post Types with OR Not Working
  20. How can I get the number of custom post type posts that have a specific attachment image set?
  21. Trash / Draft a WordPress custom post after custom date field expires
  22. Set a maxlength for the title input in a custom post type
  23. Posting to a Custom Post Type from front end – user generated content
  24. Display custom fields from custom posts in RSS feed
  25. Bulk Update Custom Fields for Custom Post Types
  26. How can I use get_post_meta with add_rewrite_rule to build custom permalinks?
  27. Visual editor issue by having multiple tiny mce editors in a CPT
  28. WordPress Custom Fields Won’t Save
  29. Update Post Meta for a logged in user
  30. Problem querying Custom post type by custom fields
  31. Found 2 elements with non-unique id (#_ajax_nonce) and (#_wpnonce)
  32. Add custom field to Posts and sort by it
  33. Orderby CPT custom fields not working
  34. WP_Query order by custom field, then randomly order some of results
  35. A better way to add a meta box to custom post types
  36. Rows with custom columns not well formatted after Quick Edit save
  37. Database to page routing API?
  38. Plugin – Combine Meta Box Input Fields into single saveble record
  39. Two Custom Post Types Many to Many Relationship
  40. Show custom post type relationships by taxonomy
  41. get_post_meta not working on publishing
  42. Query custom post type with ACF Date
  43. Custom setting to show or hide field
  44. Custom Meta Field – Remove comma from string with str_replace
  45. Using custom field content as expression in IF statement [closed]
  46. Meta Query Not Returning Output Despite Having Matching Values
  47. How to create a custom post type with additional fields?
  48. Callback to custom field is not working in WordPress REST API
  49. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  50. Including metaboxes from custom post types in global search — continued
  51. ACF From & To Date Validations
  52. How do I set all of a particular post meta to a value within the custom post type I’m in?
  53. Query Multiple Custom Posts by Custom Fields
  54. Show image gallery from a custom field
  55. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  56. Dynamic dropdown select values depending on other custom field value
  57. How to render a custom post type template with custom fields using shortcode
  58. Disable saving posts as draft (make all posts mandatory regardless of the post status)
  59. Grouping metadatas into one
  60. Tracking changes in admin-page so user gets warning when leaving the page
  61. filter custom post in rest api with custom function
  62. Get Posts by multiple custom fields is not working
  63. How to change wp prefix for custom post type only?
  64. Woocommerce custom field search in custom post type [closed]
  65. Add custom field in comments form
  66. Custom Fields for Custom Post [closed]
  67. Order Custom Post Type by Custom Field Value
  68. Filter custom post types by a field value
  69. Displaying All Posts of a Custom Post Type in WordPress Multisite Backend
  70. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  71. Repeatable Fields Metabox with Textarea (or wp_editor)
  72. Add update or delete database records using custom post type
  73. How to use TinyMCE Editor for one of my custom post meta field?
  74. Custom REST endpoints for a custom post type with custom fields
  75. How to import a custom MySQL DB table into a WordPress custom post type
  76. How to Create a WordPress Plugin With Custom Post Type/Custom Field Features?
  77. Hierarchy and access control for Custom Post Types (CPT)
  78. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  79. How to integrate a form (Ninja Form or Contact Form 7) with Custom Post Types?
  80. First custom field value (out of several) displayed twice after query
  81. Homepage’s content is dependent on the custom field values (set automatically), how do I get homepage to update without manually updating page?
  82. Meta Query posts not showing on ending date of custom field
  83. Cannot save CPT meta box
  84. Cross reference custom post types
  85. Adding Page Templates to post but it ignored it
  86. Include related custom fields from one post type in another post type’s JSON feed
  87. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  88. frontend image post uploader
  89. WP_Query orderby and tax_query
  90. Is there any way to add a “custom field” to the CPT archive page?
  91. How to Output which matched meta_keys were found from custom_type_posts?
  92. Multiple Frontend Filters Using Advanced Custom Fields
  93. Custom Post Fields at the beginning of a Custom Permalink
  94. Integrate Custom Post Type Events into Calendar
  95. Possible to filter custom post type with multiple meta data?
  96. Hierarchical custom fields
  97. How to get a custom field value of a custom post?
  98. Fields for different parts of a page
  99. Is it possible to activate customfield ‘text description’ upon activating the customfield ‘checkbox’?
  100. Facebook social publisher and custom post type fields [closed]

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)