how to speed up a complex wp_query?

What the user has read is a property of the user not of the topic. You need this information per users and for this you need to stored values in the user’s meta. You might also want to know which users read a topic so your current system is not mutually exclusive, but it is conceptually bad which results in it being slow.

Related Posts:

  1. Nested meta_query with multiple relation keys
  2. WP Query Args – Title or Meta Value
  3. Does tax_query really beats meta_query in all situations?
  4. ACF Relationship Field Search Filtering [closed]
  5. Query WooCommerce orders where meta data does not exist
  6. Query Multiple Post types each with own meta query
  7. Execute a large WP_Query with many “AND” Meta_Queries?
  8. Query all posts where meta value is empty
  9. WP_Query min and max values
  10. ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
  11. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  12. Is “orderby” in WP Meta Query conflicting with Meta Query?
  13. WP Meta Query for some meta (array) values
  14. Sort users by meta_value_num
  15. meta_query with array as value
  16. Using WP Query to search within ALL keys in meta query
  17. WP Query – Get WooCommerce Products with variation that is in stock
  18. Meta_query with or without value
  19. Meta-value query
  20. Meta query field order together with post_date order causes posts without the meta field to be unordered
  21. How to show recent and upcoming birthdays using meta_query
  22. pre_get_posts filter meta_query without conflicting existing meta_query
  23. Undefined property: WP_Query::$post
  24. Programmatically set ‘meta_query’ for filter
  25. Using WP_Query and WP_Meta_Query Outside of WordPress
  26. If two first numbers exist in wp_meta_query value
  27. WP_Query meta_query >= date
  28. Extending woocommerce admin product search
  29. WP_Query on custom field and order results
  30. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  31. Tax query clause inside a meta query clause?
  32. Adding an array from a query string to a WP meta_query
  33. Query multiple meta values
  34. Optional Meta Query
  35. Query by multiple meta elements not seeming to work – wordpress is timing out
  36. How do I make a meta_query OR relation work? [closed]
  37. Meta_query on same meta key, with diffrenct values
  38. Can we return all category (not post) with Custom Query Filter? [closed]
  39. Extend product search with meta in WooCommerce
  40. How does one perform a sub query with different post types
  41. how to make members list directory through wordpress post custom meta key.
  42. WP_Query with meta_query dosen’t return results
  43. Query posts with “non set” meta value
  44. Ordering a mysql style datetime stamp with meta_query
  45. Wp_query with 2 meta keys and array of meta values
  46. Advanced WP_Query with meta_query, orderby?
  47. meta_query: check if number exists
  48. Event with multiple dates, display events chronologically
  49. Issues with search after added meta_query
  50. Display posts with specific value first in query
  51. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  52. How to create dynamic value in WP_Query meta_query
  53. query post by author gender
  54. How do I add an item to the WP admin menu?
  55. Multiple meta query from array
  56. WP Query / Meta Query [duplicate]
  57. Query posts by searching for a string in a meta field
  58. WP_Query with 4 post meta field arguments gives 500 internal server error
  59. Use have_posts() with array of post results retrieved by $wpdb->get_results
  60. Query multiple post types, but different order for each
  61. How to add date_query to meta_query array
  62. Order by the first array within a meta_query
  63. Query ACF relationship field – Comparator IN – Value array
  64. Combine query in WP_User_Query()
  65. Multiple nested meta queries
  66. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  67. Custom meta_query order for Elementor based on post meta key [closed]
  68. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  69. How can I modify the query by adding to the existing query?
  70. ElasticPress is (aparently) messing with my search filters
  71. Multiple meta_query not returning rows
  72. WordPress Query custom ordering by temporary variable
  73. Comparing Meta Field date in WPQuery using Meta_Query?
  74. Get unique post by meta value using wp_query
  75. How to create better WP_Query to look for date time which is anywhere between two meta values?
  76. WP_Query, ACF field and array
  77. Order by Date Custom Field
  78. Filtering WP_Query based on wp_postmeta keys values
  79. WP Query. Ordering posts by another post types meta
  80. Multiple meta_query not working
  81. compare for multiple meta values for same key in wp_query
  82. datetime picker, timestamps and meta queries
  83. WP_Query with meta_query won’t orderby
  84. meta_query only check if both value are set
  85. Get posts meta_query by repater field
  86. Query 3 meta_key and orderby
  87. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  88. meta_query not working with the_content()
  89. Using custom field as ‘orderby’ value causing post grouping by publish date
  90. Get closest event where meta_key field is an array
  91. Meta_query weird behaviour
  92. Looking for a way to exclude frontpage and nav menu from query filter
  93. Creating Custom Query
  94. Get posts by meta value except one post [closed]
  95. WP_Query by meta key not returning any posts
  96. WordPress extremely slow when using get_posts with multiple meta_query relations
  97. Use meta query only 3 or more results?
  98. Use value from meta key array for use in WP_Query
  99. WordPress – Optimize the Meta Query for 3 meta keys at a time
  100. WP_Query filtering in ACF field containing dates