How to fix slow comment query?

Related Posts:

1. How to delete all records from or empty a custom database table?
2. Custom comment type maybe?
3. Get number of comments after modifying comment query
4. Akismet plugin is deleting spam despite preferences
5. Leveraging WordPress Comments on Custom Plugin Object page
6. FacetWP group listings by custom field [closed]
7. Send reply with pre-prepared answers
8. Redirect to another page using contact form 7? [closed]
9. How to insert multiple postmeta values with one query?
10. Moving FB comments at the end of page
11. Delete data from custom table when deleting a post
12. Display WordPress comments before the plugins?
13. any word search WordPress
14. Plugin does not create a custom table upon activation
15. Action hook “wp_insert_post” works but not for last imported post
16. get_var result empty for query of custom table in plugin admin
17. wp_query for more fields plugin
18. How to fix vanilla comments extra iframe space
19. Is there a way to alter the order in which the plugins appear in the page?
20. Getting Post details when post is published
21. Override the filter from plugin in child theme
22. force customers to add only single item to card per purchase EDD [closed]
23. Preventing BFA in WordPress without using a plugin
24. medoo framework in WP plugin
25. WordPress logo upload option in theme panel
26. Custom plugins/Manipulated plugins: Always a terrible idea to inherit these types of WP sites that discourage updates? [closed]
27. Delete Associated Media Upon Page / Post Deletion
28. Accessing GET variable named ‘error’
29. How to check what plugins used to be on a WordPress installation?
30. wordpress.org codebase
31. Inserting large amounts of data into a custom table during plugin install
32. Function to prevent users from trashing comments
33. Output HTML only on individual post view
34. Possible to replicate economist.com’s debate section in wordpress? [closed]
35. Can a plugin deactivate and delete itself once installed and activated?
36. WP_Query ordering numbers as letters
37. Manually add order item with fixed product_id in WooCommerce
38. How to modify shortcode attributes with data from current post
39. ‘Customize’ button in admin bar for CSS
40. add_filter comment_edit_redirect not working
41. How do you override the default comment template?
42. plugin ajax to external php file always return null
43. Auto delete WordPress users according to time
44. Plugin Customization Lost During Plugin Upgates
45. How to change commenter links to /user/user_id?
46. Facebook plugin shows existing comments
47. How can i list random post from multiple category?
48. unregistered user can write in blog page – possible? how to?
49. how do i remove posts from a WP_Query so the pagination is right?
50. How to import my YouTube channel into WordPress?
51. Is it possible to use WordPress as an online portfolio for text content? What kind of theme would I look for?
52. Custom Field Template seriously messed up in WP 3.1.1
53. How can I get WordPress to save comments in markdown format?
54. My Category is too big on the Menu what can i do?
55. how to load the language file in plugin?
56. Plugin upgrade issue
57. How to use get_theme_mod in gutenberg editor wordpress?
58. Get IDs of Images from Gallery Block in InnerBlocks of a Custom Gutenberg Block
59. How to embed HTML code from WP Coder plugin (or other) into Main Index Template of the theme
60. Accessing post’s meta data based on user’s click of a post
61. WordPress plugin – Error “Plugin generate 2890 characters of unexpected output when activated”
62. When to call add_filter
63. How can I capture Memberpress user info after signup [closed]
64. My plugin wants to update another plugin
65. WooCommerce shop page orderby [closed]
66. I have no idea “How change font for elements in widget?”
67. View Private Published Page with URL Code (no login required)
68. Get posts from WP_Query and format them on admin_head
69. JS Support Ticket – Auto create WP account
70. How to show Recent Page instead of Post?
71. Not getting author rank when using return
72. Remove Duplicator plugin from admin menu if not an administrator
73. Doubt using $wpbd->get_col for a single column
74. Input with spaces in Shortcode attributes overwritten by defaults
75. How to query the custom fields by language?
76. Access WordPress database outside of WordPress
77. How do I “get the next 10 posts after post_id == x”?
78. Add a custom form on the post-new.php admin page
79. Removing customise fields during plugin uninstallation
80. Correct way to perform non-cacheable DB query
81. Creating a plugin to sanitize comment and the url field before display only
82. Edit Yoast SEO breadcrumbs output [closed]
83. What’s the best way to implement AJAX in WordPress?
84. How to Create a Custom Panel and Fields in Post Page [Plugin]
85. Translating long texts with html formatting
86. switched from query_posts to WP_query, not working now?
87. Help With MySQL to WPDB Query Conversion
88. AJAX search posts and pages
89. How would I go about creating a user ranked post popularity page?
90. Anonymous Postings
91. Fastest way to get the comment and ping total count for a post
92. Do widget options need to be escaped widget()?
93. Is there any W3C compatible Share & Follow plugin?
94. Does any one have Idea to get these functionalities with the plugin wp-multi-network
95. Creating mySQL procedure with $wpdb
96. DROP TABLE with uninstall hook not working
97. Problem with creating tables for Plugin
98. Disable woocommerce cookies and delete cart data automatically
99. WordPress comments not appearing in blog posts, likely because of Redux template. Could I fix this with a plugin that adds a comment form as a block? [closed]
100. className not populating in custom block