I think, an idea would be to save your values on a new small table with all you need, and have a script that once every “n” hours update all metas.
Related Posts:
- update_post_meta performance in a loop woocommerce
- Should I use Transients with W3 Total Cache APC Caching? [closed]
- What is the most efficient way of querying posts based on visits and date for current day?
- Slow SQL_CALC_FOUND_ROWS Query
- What is an efficient way to query based on post_meta?
- WP_Query Performance Issues with meta_query
- How to increase load time of an archive/search page (WP_Query)
- Which is faster wpdb & get_row or wp_query & ge_post_meta?
- Woocommerce: order posts by meta key
- WP_Term_Query->get_terms() very slow query for WordPress filter
- Website goes slow down after importing long database
- Optimising amount of calls to custom fields
- WP_Query by meta key not returning any posts
- querying data via $wpdb and get_row
- wp_Qwery works to slow
- Show all data in database table and make it into an interactive table
- No results found from a $wpdb->get_results() query when trying to join more than one meta key query
- get_post_meta slowing down my page load (in a plugin)
- New WP_Query loop in admin causes problems
- echo a specific meta_key queried through a custom post
- database query with more than a couple meta hangs and doesn’t complete
- use of 10 new WP_Query : loading too slow (with url) [closed]
- get_post_meta in WP_Query
- How to access custom WordPress database tables
- wp_query not working with post_type
- Hide posts with meta key in WP_Query
- Woocommerce – exclude only older out-of-stock items
- Is it possible to query from external database? [duplicate]
- Need Sub-category with main Category
- Woocommerce pagination and result count after custom loop
- How to query woocommerce product by pricing? [closed]
- WP User Query with Custom Fields and Search Results
- Filter posts by comparing custom meta value against postdate
- WordPress query posts with multiple post_meta data
- How to order WP_Query to group results?
- WP_Query – Accessing MetaValue from Query Result
- What is the best way (regarding performance) to set transients for logged in users?
- I need query_posts() to order results first by a meta value and then by post ID
- Query child posts with tax query on parents
- Look for string in posts and postmeta
- Woocomerce – Order products by float attribute in archive pages
- Not able to fetch woocommerce variation sales products for particular category products
- Query postmeta based on meta_value, return array of post_id
- Slow Query with more 100 products
- update_post_meta() not updating
- Create global array to compare inside a query
- Separate by Category Post Type
- I removed the “wp_rm_logs” table and am constantly getting this error
- Get posts with any value in attribute
- Showing the correct number of posts_per_page when avoiding the use of post__not_in
- How do i query woocommerce booking post type on init action?
- WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
- Calculating efficiently on large amount of data generated by wp_query
- I can’t get post based on its postmeta value and key
- How to add in WP_Query to every 3 posts displayed? [duplicate]
- Woocommerce WP_Query post__not_in problem
- Saving custom fields for WP_Query to retrieve
- Meta key in wp_query bug?
- How to show all the associated posts with specific date of data metabox?
- Track write actions to the database
- Using the same WP_Query for shop and widgets in WooCommerce shop
- Woocommerce orderby rand with tax_query not random
- WP Meta Query at depth 2
- WP_Query with child element
- Include post_status check within $wpdb query
- Sort by meta key within same day
- wpdb get_results() returns only 2 rows
- CPT or Custom Table for Repository of Serial Numbers
- WP_Query always returning the last custom post
- WP_Query Posts by Metadata from Option Tree
- option select form always deleting the sql query
- Sorting Posts with meta value not working
- How to get several fields from wp_query?
- WP Query to order posts by multiple meta fields
- Return a single custom post from multiple meta queries
- Custom Search Query – include only custom fields and title
- How to count post meta key values for all posts in database
- Post OrderBy slow performance
- How to query post ids liked by the Author
- loop through custom post types with meta data
- query by meta value then date and not empty meta value
- wordpress sorting using array merge by price in ascending order but price with 0 must be show last
- Query posts by meta value and sort by another meta key
- 294 Queries on Mainpage of WordPress
- Adding arguments to WooCommerce Product Loop using AJAX
- Show linked products using wp query and woocommerce
- how to add limit records in wordpress query
- Custom WP_query in Jnews theme returns thousands of posts
- Filtering product search results using tags
- What effect can a large wp_post table have on overall site performance?
- SQL query into to WP query
- Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
- Variations as Single Products [closed]
- Extend search query to search meta keys values based on search string
- WP_Query (or WC_Product_Query) out of memory
- How to get posts that have certain meta key value and order based on another meta key’s value
- Converting longtext to mediumtext in WordPress wp_postmeta table
- How to get products with the same custom attribute like ean code
- Optimizing AJAX Query with Large Database
- How could i add username field in WooCommerce