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
- How to only display posts whose meta_value field is not empty?
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Reduce or prevent calling of update_meta_cache
- Query WooCommerce orders where meta data does not exist
- Get posts by menu ID
- WP-CLI How to generate a list of posts with corresponding meta values
- Get WooCommerce best selling products for the current month [closed]
- Woocommerce query by price range and custom meta key
- Stop all SQL_CALC_FOUND_ROWS wordpress queries
- How to count post meta key values for all posts in database
- How should I use posts_where to change meta_value from a string to integer?
- How can I create a WP_Query that returns posts where one meta_value
- WP Meta Query for some meta (array) values
- query posts in functions.php and update a field
- Find all product that contain terms with %keywords% in WP_Query
- WP Query – Get WooCommerce Products with variation that is in stock
- Get the post permalink within the loop but without additional DB query
- Filter WordPress posts by between parameter
- Search product by brand name in wp_query
- Query Posts depends on custom field inside repeater field using acf
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- Minimising Database Queries when using Advanced Custom Fields
- Pull post meta with post_query?
- WC displaying products from category
- Get all products which have both product category
- How to make Meta Query case sensitive?
- Performance when getting post meta for post retrieved by meta value
- Fastest way of counting posts of a custom post type in a specific taxonomy term?
- Use more than one query, but prevent duplicates – at scale!
- WP_QUERY to display woocommerce products whose author IS the logged in user
- Is it a good idea to improve meta query performance by adding tax query?
- WooCommerce – get product sub categories
- How to implement a new row_count method in WordPress?
- Out Of memory issue on post per page parameter
- How do I query for posts by partial meta key?
- No results found from a $wpdb->get_results() query when trying to join more than one meta key query
- New WP_Query loop in admin causes problems
- get_post_meta in WP_Query
- How to access custom WordPress database tables
- Hide posts with meta key in WP_Query
- Need Sub-category with main Category
- Woocommerce pagination and result count after custom loop
- WordPress query posts with multiple post_meta data
- Can’t fetch Custom Post Type Data through Custom Query
- how to get Nearby zipcode
- Should I use docker in wordpress production?
- How do I get Woocommerce product variation name and variation description in a WP_Query?
- Slow Query On Search
- Multiple meta_key ordering with pre_get_posts
- Wpdb->query result show 1 but is not an integer
- var_dump of WP_Query object is not empty, while .have_posts() return false
- Nested array issue in meta_query
- WP_Query with page_ids in arguments without a result
- WP_Query meta compare must include ALL array values
- Disable (or limit) queries when certain content (or data) is not needed (or showed)
- Woocommerce Shortcode which displays a table with product data
- Customize the Sorting Dropdown in WooCommerce use another list or more page
- wp query to use both author id and meta_query
- Why last row deleted when refresh page
- WooCommerce WP_Query using tax_query returns no results (0 = 1)
- How sort products by calculate value? ( custom post meta, price, option)
- wc_get_products() return empty object
- How can I filter products by meta in Woocommerce REST API?
- show most viewed post
- Query a database based on form input then output to another page [closed]
- How to get meta key list efficiently?
- Select multiple categories with is_tax
- How to extend WP_query to a specific table?
- How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
- 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
- Separate by Category Post Type
- I removed the “wp_rm_logs” table and am constantly getting this error
- How do i query woocommerce booking post type on init action?
- Calculating efficiently on large amount of data generated by wp_query
- Woocommerce orderby rand with tax_query not random
- Include post_status check within $wpdb query
- WP_Query always returning the last custom post
- How to get several fields from wp_query?
- Return a single custom post from multiple meta queries
- 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
- 294 Queries on Mainpage of WordPress
- Show linked products using wp query and woocommerce
- Filtering product search results using tags
- Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
- Extend search query to search meta keys values based on search string