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
- order by numeric value for meta value
- Use REGEXP in WP_Query meta_query key
- How to query only for products with status “in stock” in WooCommerce? [closed]
- Is there a way to extend WP_query so Custom Post Types can have properties?
- Getting attachments by meta value
- WP_Query displaying ALL posts
- WP_Query not working as expected for attachments and custom meta_query
- WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
- Group posts by meta_key
- How to solve slow WordPress site caused by attachment_metadata
- Retrieve products with specific attribute and in category – woocommerce
- How to combine tax_query and date_query in WordPress
- how to retrieve specific product attribute value in an sql query?
- Custom URl parameter
- Compile meta values from custom loop into array and then calculate sum total
- How to get sum of meta_values of a meta_key in wp_query according to conditions
- Slow speed and high CPU usage for my code. How to improve it?
- Multiple queries on Home Page – page load/site speed issue
- Best approach to create Hot and Trending sections
- Should close $wpdb via $wpdb->close()
- Order posts by meta value and Date
- Retrieve featured image (thumbnail) url from multiple posts with one query
- Efficient way to update multiple post meta
- How to make orderby ‘meta_value_num’ OPTIONAL?
- Order by custom table and multiplication
- WP_query posts closest to todays date
- Woocommerce returns Product post_status as published even tho it is in status draft
- exclude posts with a specific custom field and value
- showing all search result in one template
- Structure of postmeta meta_value for woocommerce product download
- Using hook to use DISTINCT in a wp_query
- Take all produts by category
- How to get all product attributes for filters in WooCommerce?
- Fetch Record based on meta key dates
- Where to put meta Keys
- Should wp_query automatic meta and term cache priming be used in an enviroment with an object caching
- Large AND OR query timing out
- querying data via $wpdb and get_row
- get_post_meta slowing down my page load (in a plugin)
- use of 10 new WP_Query : loading too slow (with url) [closed]
- Woocommerce – exclude only older out-of-stock items
- 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
- How to order WP_Query to group results?
- What is the best way (regarding performance) to set transients for logged in users?
- List of ways to access WordPress database?
- Redirect Search to Form When No Product Results Are Found
- Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute
- How to echo woocommerce category name
- Why having more than 10 clauses in WP_Query results in some outputs being dropped?
- How can I update post meta inside a WP_Query loop or the WordPress loop?
- Function to retrieve IDs of posts, cache results, and improve wp_query
- Orderby two meta fields not working
- Unlimited Page Sitemap Link
- How to avoid filling up an array each time I run a WP_query?
- Display count number of posts with the same specific meta_key meta_value
- Query posts by searching for a string in a meta field
- Make a products only viewable to a specific user ID in meta_query pre_get_posts
- How do i create a custom post query when the meta value is an array?
- Get categories within specific term
- How to get user avatar via WPDB
- How to display Woocommerce products list by tag
- Fix wp_term_relationships slow query in get_posts
- Ajax buttons not working properly in WooCommerce when using wc_get_template_part
- 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
- update_post_meta() not updating
- Create global array to compare inside a query
- WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
- How to add in WP_Query to every 3 posts displayed? [duplicate]
- Woocommerce WP_Query post__not_in problem
- Meta key in wp_query bug?
- Track write actions to the database
- Using the same WP_Query for shop and widgets in WooCommerce shop
- Sort by meta key within same day
- CPT or Custom Table for Repository of Serial Numbers
- option select form always deleting the sql query
- Sorting Posts with meta value not working
- Post OrderBy slow performance
- How to query post ids liked by the Author
- loop through custom post types with meta data
- how to add limit records in wordpress query
- SQL query into to WP query
- Converting longtext to mediumtext in WordPress wp_postmeta table