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
- WP_Query does not return the result even if the data is present in the database
- How do I turn a custom post type into a plugin?
- Plugin exceeds memory limit
- How can I implement a notification system in wordpress?
- Redirect to a welcome page after updating plugin
- medoo framework in WP plugin
- Find the URL of the current plugin directory
- WordPress logo upload option in theme panel
- How to automate wordpress plugin activate and deactivate by php logic?
- Custom plugins/Manipulated plugins: Always a terrible idea to inherit these types of WP sites that discourage updates? [closed]
- Where does WordPress register default scripts like jQuery?
- Minimum PHP Required for WordPress
- Adding content before the loop in category pages
- How to get variables from fucntion.php to my plugin files
- admin_notices hook show message all admin pages after plugin activate
- Adding Attachment Display Settings in custom media frame
- Set user ID at time of wp_create_user
- How to include code into functions.php file via a plugin
- building plugin and it is displaying above plugins page
- like to keep reading plugin
- Check if email address exists front end with AJAX in a plugin
- Avoiding Duplicate function names in Post Loop (WP_Footer script)
- Default Plugin Settings Not Writing to Database
- add action for displaying posts using a shortcode
- How do I write into a file (css)
- WP Plugin Developers – Accessing my wordpress site [closed]
- How to make a custom field as an editor in wordpress?
- WordPress Automatic Plugin Update Renames Plugin Directory
- How can sanitize $_FILES[‘haq_slider’] field
- Why is an action callback function from an instance of a class always invoking the same function from an instance?
- Write to / remove from default .htaccess file from plugin?
- ‘wp_login’ action hook not working with wp-login.php file
- FacetWP group listings by custom field [closed]
- Is it possible to enqueue CSS files from plugin before theme’s CSS files?
- Update Option Error: Notice: Undefined index
- Why this global array is returning NULL from a callback function
- Demystifying and understanding shortcode nomenclature
- How to define WordPress plugin shortcode globally for multisite?
- download_url() appears as grey icons
- Global matrix for shortcodes/content for every page
- Plugin not appearing after uploading it via FTP
- How to add class in plugin only for network site?
- Where to hook my plugin’s action
- load_theme_textdomain path
- how to Include json manifest file in wp plugin
- Plugin Development sqlite or WordPress’ database
- Is there any way to get all the name or slug of template parts used in a page?
- Dynamic CSS Vs Inline Issues in Code any Way around in a WordPress Themes?
- Is license need for free wordpress plugin
- How to make Http Request to a php file present in plugin directory of wordpress
- Create a custom page template inside my wordpress plugin
- Retrieving plugin options value saved through setting