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. Hide custom post type field from author?
  20. echo value from ‘select’ field type into page template using cmb2?
  21. How to use custom database tables for custom post types?
  22. How to hook get_terms() to only show count of posts that have custom meta
  23. ACF Relationships in Custom Post Type Permalink
  24. Search Custom Post Type with all meta attached?
  25. Automatically assign a custom post to a custom taxonomy based on custom field value
  26. Not sure why my custom post meta field isn’t saving
  27. Display two post types ordered by two custom fields
  28. How loop through posts based on custom fields
  29. Sort by two dates. Default entry date and custom field if present
  30. Get Custom Field Values by Another Custom Field in WordPress
  31. Conditional to modify query results
  32. Create a random unique 6 digit number as custom field for custom post type
  33. Get all Posts If has same custom field values in Posts
  34. Retrieve value of a category’s custom field
  35. Rewrite and custom post type: order by custom field not working
  36. wp_query check if integer exists in custom field’s array
  37. Add field to all custom post types
  38. How can I use get_post_meta with add_rewrite_rule to build custom permalinks?
  39. Visual editor issue by having multiple tiny mce editors in a CPT
  40. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  41. Dynamic dropdown select values depending on other custom field value
  42. Grouping metadatas into one
  43. Add update or delete database records using custom post type
  44. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  45. Include related custom fields from one post type in another post type’s JSON feed
  46. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  47. Displaying and searching Custom Posts
  48. How to let users choose where to search for posts?
  49. It’s possible to hide body copy box for a custom post type?
  50. Show data from one Custom Post Type in another Custom Post Type
  51. How can I add a custom field to an existing custom post type?
  52. How to get a custom type post data when it has a connection with another custom type post?
  53. Display Repeatable Meta Box Content
  54. WP_Query orderby not work with meta_key
  55. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  56. Custom Field not saving in WordPress
  57. Reusable metabox backend and frontend
  58. How to display wp_post by custom field value?
  59. How can I modify a custom post type and custom page template for a child theme if all content seams to be handled by theme’s ‘native’ plugin?
  60. WordPress as a frontend website for iOS app [closed]
  61. Get A Custom Field From A Custom Taxonomy Of A Custom Post Type [closed]
  62. “Custom Field” to Excerpt field” for pages? [closed]
  63. Let users upload image(s) to the post from front end
  64. How to import database table as custom post type and custom fields?
  65. Custom Taxonomy dont save in a frontend form for post a custom post
  66. Insert custom fields to a custom post type
  67. How to display posttypes and taxonomy in standard posts, not in a separate label?
  68. Fill custom fields when saving custom post types
  69. Should i use custom post type for a custom footer?
  70. Use Gravity Forms and a Shopping Cart for output to Freshbooks for an Estimate [closed]
  71. A sports wordpress website
  72. How do I ensure that post_type and Taxonomy use the same slug?
  73. How to make an API call to a custom post type but filtering by meta value?
  74. Migrate Custom Post Type with Custom Fields data and parent child order
  75. Custom Post Type meta data getting deleted on bulk editing taxonomies
  76. Custom Form / Search with Custom Post Type Data
  77. wp_set_object_terms creates taxonomies but does not add custom posts to it
  78. Custom Column in CPT admin table not updated after Quick Edit save
  79. Display Custom Field or Custom Taxonomy in front page /post/product
  80. PHP Warning with Custom Fields
  81. Custom post types & Pages hierarchy – Error 404
  82. filter rest api post by a acf filed
  83. How to prepend text to custom field value A, but only if custom field value B matches a certain string?
  84. How do I extract the contents of a CPT’s custom field for all posts?
  85. How to delete comma from the end of results? [closed]
  86. Publish post and create additional posts with same content
  87. Creating multiple CPT posts from one Gravity form
  88. Converting a checkbox filter for custom fields to a dropdown
  89. Function not pulling image or text from custom post type
  90. Custom field totals
  91. If i have custom post type with 5 custom fields do i have to create a new loop to reference each one?
  92. How to show animal lineage/pedigree in WordPress?
  93. WP_Query arguments: Loop through custom post type – get all entries except excluded meta_key?
  94. Types plugin isn’t compatible with my custom post type
  95. Show Posts in Vertical Tabs with Scrollbar
  96. How do I filter a custom post type loop by a field?
  97. Custom Post type as Taxonomy
  98. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  99. Update Custom Field daily within 7days
  100. Remote database access on another wordpress site’s custom post type

Leave a Comment

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