As mentioned in the comments, post_status
is stored in the posts table but postmeta values are stores in postmeta table which is usually a much more heavy table than posts. Using a meta in db queries, results in adding a JOIN clause to the query to join this heavy table!
So using post_status
is definitely a better performance choice.
Related Posts:
- Get posts by meta value with date
- Is it possible to retrieve a post and its metadata at the same time?
- How to save HTML data into SQL post_content column
- Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
- Adding meta tag without plugin
- Sanitizing integer input for update_post_meta
- Meta compare with date (stored as string) not working
- How to update/insert custom field(post meta) data with wordpress REST API?
- Front-end update_post_meta snippet displays white screen?
- How to get meta value in wp_attachment_metadata
- Clean up output added via wp_head()
- get_post_custom()
- Get post from meta_key and meta_value
- get_post_meta returns bool(false)
- How to get custom post type to display post meta on archive pages?
- Mass importing json data into custom fields (postmeta)
- How to echo get_post_meta (Fluent-Framework)
- WP_POSTMETA changes site crash
- meta_post_meta return value 1
- How to use post_id with a Class?
- get_post_meta remains empty while looping all menu items and using the ID
- Set default Custom Post Meta Value
- INSERT ON DUPLICATE KEY UPDATE failes in postmeta table
- Set Checkbox as checked by default
- replacing the_autor or make callback
- Some post meta fields stop saving after a few successful saves
- update_post_meta saves nothing in database when run in publish_post
- Can’t access post meta on new post creation (cpt)
- Save an array of values in the post meta box
- Custom post meta values reset by autosave [duplicate]
- Compare meta_query with a Regular Expression and do a less-than operation on it
- get_post_meta() empty in preview WHEN custom post is published [closed]
- Add Embed.ly API objects to post_meta on update
- Editing does not change post_name
- Compare string with post id in wpdb and do stuff when match is found
- $wpdb class updating meta_value using Ajax [closed]
- Display post details by post ID
- Post meta as array looks like string instead of array
- How to selected which tags to print, instead of printing the whole tag list?
- query posts and split meta information into separate div’s
- How to test the outcome of a wpdb query?
- Mass removing CSS from 1,700 post [closed]
- How do I manage custom meta in post revisions in the Block Editor era?
- Generate metadata for cloud images
- Migrating meta value to new meta value
- Is there a way to disable post meta caching for development?
- Insert multiple metas in one time
- How to extract data from a post meta
- Correct meta of Writing Meta Tags
- How to add tags to post from frontend?
- Retrieve user_meta and copy to post_meta
- update_post_meta not working?
- Change wordpress meta tag description using WP functions
- troubles with get_post_meta (and saving it)
- Cant create or update meta fields using WordPress REST API
- Filter posts by meta key
- Display current ranking of post as a number in post title
- delete duplicates wp_postmeta
- Post Thumbnail missing when using webp format while sharing
- Bulk Update Post Meta Values from Different Post via Rest Api
- update_post_meta() is not saving the value
- Only show meta on one post type on search results page
- How to register post meta with multi level arrays?
- How to exclude posts by meta key value in the_post_navigation next prev links?
- If I disable screen options, does WP still try to update post meta?
- Can we have duplicate key pair values in post meta data?
- I created a Custom Meta Box but it is not displaying the value on my post page
- Meta data being pulled from wp-login.php
- Update post meta date always store 1970-01-07
- Is it possible to pass an whole array using custom field in wordpress?
- Get post content before rendering
- wp_insert_post inside save_post adds wrong metadata to inserted post
- Rename image filename using ‘media_handle_upload’
- How do I update a specific value within array in a products metadata?
- Update Post metafield of specific categories
- Optimize WP Meta Query for large amount of post meta?
- Using Self Hosted Video URL With Custom Fields
- Multiple postmeta values to the same post_id/meta_key combination?
- get_post_meta not work in php foreach
- Why are my custom metaboxes not updating the post meta?
- Problem serializing single quote and double quote into post meta
- Storing post_meta fields in array
- Performace on 1 million plus meta fields vs 1 field with 1 million multi array
- Fetching array of postmeta with $wpdb and in_array conditional
- Piklist File Upload
- php wp_insert data on front using a form
- Updating post_meta when updating a setting with the Settings API
- How to show specific meta keys of all posts in admin panel?
- wp_schedule_event not working
- how to echo/display the custom field value in specific custom field name?
- update_post_meta() not working in bulk option
- How to update the ‘modified_time’ of a post ONLY when content is changed?
- Multiple If else statements on Search Result Page
- WordPress join posts with meta values of array type
- How to make certain content of the post noindex and no follow. not entire post?
- Export posts with postmeta without ID?
- get_children filter with postmeta
- How can I display my meta value in a textarea? [closed]
- Auto save title as custom meta field value
- Save frontend submission form field as custom field