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:
- WP-Snap too slow (caused by WP_Query?)
- Creating two database tables via plugin
- Query Posts by Custom Field ‘Price’
- WP_query parameters for date range
- Update Multiple Post Meta for the Same Post In One call?
- Comparisson between date() and a date from wp_postmeta
- Updating post meta for custom post types
- How can I add a custom meta value on file upload?
- How use %like% in sql statement wordpress
- Accessing GET variable named ‘error’
- WP_Query ordering numbers as letters
- Is Wrapping intval() Around esc_attr() Redundant for Escaping Input?
- Call to a member function have_posts() on a non-object on normal loop
- switched from query_posts to WP_query, not working now?
- AJAX search posts and pages
- how to use in custom single.php template using php?
- How can I change the meta_key for a particular piece of information?
- How to create a custom shortcode based on the layout?
- ACF: post query, hide duplicate values [closed]
- Redirect to another page using contact form 7? [closed]
- How to insert multiple postmeta values with one query?
- Render content of multiple pages and their descendants
- order posts by `meta_key`, Does not display posts that does not have `meta_key`
- Adding custom meta boxes to specified custom post type
- Set Multiple Meta Values as an Array Using dispatch( ‘core/editor’ ).editPost() Call in Gutenberg/JS
- Remember the Meta Value With Radio Buttons
- Delete data from custom table when deleting a post
- How can i listing current category and Featured Category post list?
- Help to Create a Simple Plugin to make a post
- How to Join wp_posts & wp_postmeta table using custom query
- how to auto random increment for post view
- adding dynamic/multiple slug values in ‘option_none_value’
- custom post type get_posts() function not work
- How to securely controlling data without keeping it in postmeta?
- “Enable Media Replace” plugin does not update serialized object in WPMeta
- Checkbox field that add a subscription product and change prices of other products in checkout and cart page
- How to use information from the database in the front-end?
- How to get post that has non zero or greater than zero meta value
- Delete postmeta when uninstall/delete plugin
- How to insert variable which contain array value in wp_options table?
- Shortcode in a blog post, footer and related products stop working
- Storing values in Post Meta vs new tables
- WordPress Meta Query: Relation is not working correctly
- WordPress plugin not eching popular posts
- Making a Custom Post Type Publish Loop
- Checking url from plugin [duplicate]
- wordpress last all added get meta value by post id
- Accessing Correct Database to Create REST API Endpoint
- Edit plugin without hooks in functions.php
- Making plugin unique to not conflict with plugins with the same name
- Is dynamic forms/entries possible in Widget?
- How to get posts by content?
- Trigger a custom wordpress plugin with a linux cron
- How to integrate plugin in WordPress theme
- How do I write into a file (css)
- Allow users of my plugin to define their own shortcode rather than use mine?
- CRUD and Frontend show from a custom table without shortcode
- How can I make 2 plugins that include different versions of a framework to both use the latest version?
- Add Plugin options as subpage to Theme options page
- Image upload and download from front-end
- correct way to include a library(and its dependent libraries) in wordpress development
- Issue Tracker from pre exsisting table [closed]
- How to call WordPress function other files
- Git Hosting for WordPress SVN Plugin Repository [closed]
- Stop Plugin from Getting Styles from Other Plugin
- Date format – Meta Box plugin
- Default taxonomy template in plugin, override in theme
- How to add support for caching plugins for my own plugin?
- woocommerce search by sku and title ajax
- WordPress Site is Broken, Cannot see wp-admin page [closed]
- wp_loaded with static Singleton
- How to remove a CPT Menu from the Root Admin only
- Get post_id on clicking a link in WordPress
- WordPress.org: How to add a plugin for certain countries?
- How to remove menus items from Menu section from WordPress theme customizer
- Wp Debug Enabled True Notices and Warning
- Plugin generated unexpected output – No PHP errors
- Scrape key check failed. Please try again
- Is there any way to sync Facebook Comments and with comments on WordPress website?
- Woocommerce convert simple products to variations
- WordPress Ajax request “Failed to load resource: the server responded with a status of 400 ()”
- Load my Inline js footer area
- Remove action added in plugin class from theme
- Using multi-dimensional array with filter
- WordPress Admin sub-level menu issue
- PHP header() not available to use in my plugin
- Displaying friend’s posts only
- How to add submenu to WordPress plugin in the same Directory of main Plugin?
- How to add jquery to my custom post type wp plugin
- Check if user is in a group of another site within multisite network [closed]
- Synch Custom Post Types (and Custom Fields, Cats, etc.) Between WordPress Sites
- Redirect url in plugin to somewhere else?
- Site is setup statically – how to make it content managable?
- Output plugin post like system count [closed]
- Modifying lightbox plugin to allow for quoting, Does this exist? [closed]
- How to escape html code?
- add_meta_box showing blank screen in my page
- Use inline callable for hooks and filters
- Error in using ‘admin_enqueue_scripts’ action through a class
- How do i fix this error?