How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?

This question is too broad for a concise answer but generally speaking I’d recommend:

You can query by both the taxonomy & custom fields using tax & meta queries. There’s a premium 3rd party addition for ACF that converts custom fields to real tables if you’re working with huge amounts of data.

Related Posts:

  1. Right way of storing large number of custom post fields
  2. Custom post type or just use custom fields
  3. Using posts and postmeta table to store custom Address Book Plugin data
  4. WP All Import – Using Xpath to set a select value
  5. Sorting custom post type columns with external data and without meta values
  6. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  7. Importing Data from a Non-WordPress database, into WP
  8. Specifying meta field’s column type in Database using add_post_meta
  9. Ideas to connect external database table to wordpress posts as custom field source
  10. delete duplicate meta_value with same post_id
  11. 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?
  12. when looping through custom post data not appearing
  13. custom post types, custom fields and normalization
  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. Custom Post Type Data in Sidebar widgets?
  20. Custom Post Types, or completely custom?
  21. Hide custom post type field from author?
  22. Many to Many Relationship between Two Custom Post Types
  23. Sorting a query by custom field date
  24. wordpress plugin error handling
  25. Creating Photo Gallery System with Custom Post Type
  26. Set post title from two meta fields
  27. How to sort CPT by custom meta value (date), and return posts month by month
  28. Trying to save custom post type from frontend partially working
  29. Custom Taxonomy order by Custom Field
  30. Comparing timestamps in meta query doesn’t work
  31. Is there any performance consideration when using Custom Post Types?
  32. Custom Post Type Navigation on Custom Field
  33. how to interconnect custom post types?
  34. Saving Custom Post types and fields to a custom table
  35. Adding dropdown select meta box to custom post type – seems restAPI is interfering
  36. search also in taxonomy, tags and custom fields
  37. Filter custom posts using auto populated dropdown selectors
  38. Querying Two Custom Post Types with OR Not Working
  39. How can I get the number of custom post type posts that have a specific attachment image set?
  40. Bulk Update Custom Fields for Custom Post Types
  41. Add custom field to Posts and sort by it
  42. Two Custom Post Types Many to Many Relationship
  43. Show image gallery from a custom field
  44. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  45. filter custom post in rest api with custom function
  46. Custom Fields for Custom Post [closed]
  47. Displaying All Posts of a Custom Post Type in WordPress Multisite Backend
  48. Adding Page Templates to post but it ignored it
  49. Is there any way to add a “custom field” to the CPT archive page?
  50. Organize WordPress site, so it can maintain with huge database
  51. don’t publish custom post type post if a meta data field isn’t valid
  52. WebP Fallback for Inline Background Image in Style Attribute
  53. How can meta boxes be added to “unknown” custom posts?
  54. Custom “radio button meta box” not saving correctly
  55. Check if post with same meta value exists
  56. custom post data – how to
  57. Get Post Terms of Current Post (selected taxonomy term) – How to get only the taxonomy value and not “Array ( [0] => taxonomy term )” in the frontend?
  58. Editor / Add Media: Is it possible to only allow galleries?
  59. Running a song lyrics site on WordPress
  60. What do the numbers mean at the end of add_action(‘save_post’)…?
  61. A meta box (in a custom post type) with two different type of fields
  62. Allow front end users to add data to a custom post type
  63. Many to many to many custom post relationships
  64. copy images from custom field to another custom field
  65. Custom Query: If One Post Object Field Value Is The Same As Another
  66. Sum and count of custom field values
  67. Entity to store contact form entries?
  68. Cannot obtain custom meta information
  69. How to use a specific custom field in a custom post type as slug
  70. How do I show my containing my custom field ONLY if there is a set value on that custom field? [closed]
  71. How to hide a custom field from admin?
  72. Adding an extra parameter [string] to my posts’ permalink?
  73. Add Extra Category Field to CPT Categories
  74. Cache issue with WP_Query and custom field filtering
  75. Import External XML
  76. Empty meta-box returns publishdate if no value is set?
  77. Custom Post Type Meta Box Text Input Field Won’t Save When Blank
  78. Alike Shortcode using in Custom Shortcode
  79. What is the correct way that when creating a custom post type assign values to custom fields created with pods framework?
  80. Custom Metabox Info Not Saving
  81. Post Filtered by Custom Field Value
  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. Custom post type that lets users create a set of posts?
  85. How do I extract the contents of a CPT’s custom field for all posts?
  86. Delete custom post type metadata without deleting the post in admin area
  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. Order Custom Posts by Several Fields
  91. Custom field totals
  92. Repeatable custom meta select boxes
  93. 404 on Pages for Custom Post Type & Query_Posts
  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. Display div based on Group metabox selection [closed]
  99. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  100. Remote database access on another wordpress site’s custom post type
techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduedueduedusedusedusedusedusedus