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?
- WordPress retrieving meta data for all custom post types in list view
- Order by optional meta key?
- meta_query: using BETWEEN with floats and/or casting to DECIMAL
- WP_Query: Exclude hidden products from WooCommerce product list
- Query WooCommerce orders where meta data does not exist
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Query Custom Meta Value with Increment
- WP-CLI How to generate a list of posts with corresponding meta values
- Changing a theme’s search function to only show results from woocommerce?
- query posts in functions.php and update a field
- how to fire join query with post_meta
- Display featured products through custom loop in WooCommerce 3 [closed]
- WP_Query, custom sort and custom filter
- Get the post permalink within the loop but without additional DB query
- Minimising Database Queries when using Advanced Custom Fields
- WP_Query times out
- How WordPress attaches its Featured Images with posts?
- Improve wp query perfomance on large db
- How to get the WC_Product Object when using a WP_Query in WooCommerce
- Extending woocommerce admin product search
- reducing the amount of wp_query calls
- WC displaying products from category
- Inserting serialized value into wp_postmeta using update_post_meta
- Display custom field meta outside loop, site wide
- Sort by price woocommerce by ID post_meta
- Cluster WooCommerce products in each Category Archive by Tags assigned to products
- Extend product search with meta in WooCommerce
- Display tags with random thumbnail from selection of posts with that tag
- how to make members list directory through wordpress post custom meta key.
- How to implement a new row_count method in WordPress?
- Woocommerce – Changing the order of the upsell products [closed]
- Loop Performance > JSON files vs. WP_Query vs. REST API
- echo a specific meta_key queried through a custom post
- use of 10 new WP_Query : loading too slow (with url) [closed]
- Woocommerce – exclude only older out-of-stock items
- Is it possible to query from external database? [duplicate]
- How to query woocommerce product by pricing? [closed]
- Filter posts by comparing custom meta value against postdate
- 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?
- List of ways to access WordPress database?
- Specify strict ‘order by’ in WordPress query
- How to set up hierarchical relationships without using plugins / meta query
- Does WordPress have something like Drupal’s DB API?
- Hide products in uncategorized category from search results
- 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?
- Order WP_Query results by meta key value in custom query
- How can I update post meta inside a WP_Query loop or the WordPress loop?
- WP Query – filtering terms with regex
- WP_Query for products always returns empty
- Issue with data array format
- Performance concerns: index.php vs taxonomy-$taxonomy.php
- 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?
- Woocommerce Get Orders By Meta Value
- Save large WP_Query to transient === false
- Custom Woocommerce Product Query
- Get categories within specific term
- wp query search multi terms
- How to display Woocommerce products list by tag
- Fix wp_term_relationships slow query in get_posts
- Translating WP query into to SQL query
- Unusual high query of user meta data
- Woocommerce featured products query no longer working
- Ajax buttons not working properly in WooCommerce when using wc_get_template_part
- Look for string in posts and postmeta
- Not able to fetch woocommerce variation sales products for particular category products
- Query postmeta based on meta_value, return array of post_id
- Get posts with any value in attribute
- WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
- Meta key in wp_query bug?
- WP Meta Query at depth 2
- WP_Query with child element
- Sort by meta key within same day
- option select form always deleting the sql query
- Sorting Posts with meta value not working
- Post OrderBy slow performance
- loop through custom post types with meta data
- Adding arguments to WooCommerce Product Loop using AJAX
- how to add limit records in wordpress query
- SQL query into to WP query
- Variations as Single Products [closed]
- How could i add username field in WooCommerce