Performance considerations – postmeta table versus new table for custom posts with foreign keys?

I can`t say this is the best solution but I know you can’t go wrong with a structure like wp_postmeta.

I’ve done some custom work with GravityForms and they now use a similar structure. Instead of using postmeta there is an “entries” table. So with each form submission, there is an entry_id and multiple different entries differentiated by the meta_key. Knowing they switched to a structure like this probably indicates it’s the best solution for queries.

Related Posts:

  1. WP-Snap too slow (caused by WP_Query?)
  2. Creating two database tables via plugin
  3. Query Posts by Custom Field ‘Price’
  4. WP_query parameters for date range
  5. Update Multiple Post Meta for the Same Post In One call?
  6. Comparisson between date() and a date from wp_postmeta
  7. Updating post meta for custom post types
  8. How can I add a custom meta value on file upload?
  9. How use %like% in sql statement wordpress
  10. Accessing GET variable named ‘error’
  11. WP_Query ordering numbers as letters
  12. Is Wrapping intval() Around esc_attr() Redundant for Escaping Input?
  13. Call to a member function have_posts() on a non-object on normal loop
  14. switched from query_posts to WP_query, not working now?
  15. AJAX search posts and pages
  16. how to use in custom single.php template using php?
  17. How can I change the meta_key for a particular piece of information?
  18. How to create a custom shortcode based on the layout?
  19. ACF: post query, hide duplicate values [closed]
  20. Redirect to another page using contact form 7? [closed]
  21. How to insert multiple postmeta values with one query?
  22. Render content of multiple pages and their descendants
  23. order posts by `meta_key`, Does not display posts that does not have `meta_key`
  24. Adding custom meta boxes to specified custom post type
  25. Set Multiple Meta Values as an Array Using dispatch( ‘core/editor’ ).editPost() Call in Gutenberg/JS
  26. Remember the Meta Value With Radio Buttons
  27. Delete data from custom table when deleting a post
  28. How can i listing current category and Featured Category post list?
  29. Help to Create a Simple Plugin to make a post
  30. How to Join wp_posts & wp_postmeta table using custom query
  31. how to auto random increment for post view
  32. adding dynamic/multiple slug values in ‘option_none_value’
  33. custom post type get_posts() function not work
  34. How to securely controlling data without keeping it in postmeta?
  35. “Enable Media Replace” plugin does not update serialized object in WPMeta
  36. Checkbox field that add a subscription product and change prices of other products in checkout and cart page
  37. How to use information from the database in the front-end?
  38. How to get post that has non zero or greater than zero meta value
  39. Delete postmeta when uninstall/delete plugin
  40. How to insert variable which contain array value in wp_options table?
  41. Shortcode in a blog post, footer and related products stop working
  42. Storing values in Post Meta vs new tables
  43. WordPress Meta Query: Relation is not working correctly
  44. WordPress plugin not eching popular posts
  45. Making a Custom Post Type Publish Loop
  46. Checking url from plugin [duplicate]
  47. wordpress last all added get meta value by post id
  48. Accessing Correct Database to Create REST API Endpoint
  49. WP_Query does not return the result even if the data is present in the database
  50. How do I turn a custom post type into a plugin?
  51. Plugin exceeds memory limit
  52. How can I implement a notification system in wordpress?
  53. Redirect to a welcome page after updating plugin
  54. medoo framework in WP plugin
  55. Find the URL of the current plugin directory
  56. WordPress logo upload option in theme panel
  57. How to automate wordpress plugin activate and deactivate by php logic?
  58. Custom plugins/Manipulated plugins: Always a terrible idea to inherit these types of WP sites that discourage updates? [closed]
  59. Where does WordPress register default scripts like jQuery?
  60. Minimum PHP Required for WordPress
  61. Adding content before the loop in category pages
  62. How to get variables from fucntion.php to my plugin files
  63. admin_notices hook show message all admin pages after plugin activate
  64. Adding Attachment Display Settings in custom media frame
  65. Set user ID at time of wp_create_user
  66. How to include code into functions.php file via a plugin
  67. building plugin and it is displaying above plugins page
  68. like to keep reading plugin
  69. Check if email address exists front end with AJAX in a plugin
  70. Avoiding Duplicate function names in Post Loop (WP_Footer script)
  71. Default Plugin Settings Not Writing to Database
  72. add action for displaying posts using a shortcode
  73. How do I write into a file (css)
  74. WP Plugin Developers – Accessing my wordpress site [closed]
  75. How to make a custom field as an editor in wordpress?
  76. WordPress Automatic Plugin Update Renames Plugin Directory
  77. How can sanitize $_FILES[‘haq_slider’] field
  78. Why is an action callback function from an instance of a class always invoking the same function from an instance?
  79. Write to / remove from default .htaccess file from plugin?
  80. ‘wp_login’ action hook not working with wp-login.php file
  81. FacetWP group listings by custom field [closed]
  82. Is it possible to enqueue CSS files from plugin before theme’s CSS files?
  83. Update Option Error: Notice: Undefined index
  84. Why this global array is returning NULL from a callback function
  85. Demystifying and understanding shortcode nomenclature
  86. How to define WordPress plugin shortcode globally for multisite?
  87. download_url() appears as grey icons
  88. Global matrix for shortcodes/content for every page
  89. Plugin not appearing after uploading it via FTP
  90. How to add class in plugin only for network site?
  91. Where to hook my plugin’s action
  92. load_theme_textdomain path
  93. how to Include json manifest file in wp plugin
  94. Plugin Development sqlite or WordPress’ database
  95. Is there any way to get all the name or slug of template parts used in a page?
  96. Dynamic CSS Vs Inline Issues in Code any Way around in a WordPress Themes?
  97. Is license need for free wordpress plugin
  98. How to make Http Request to a php file present in plugin directory of wordpress
  99. Create a custom page template inside my wordpress plugin
  100. Retrieving plugin options value saved through setting