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. Best collection of code for your 'functions.php' file [closed]
20. Should all plugins be encapsulated in a Class?
21. How can I edit post data before it is saved?
22. OpenID for WordPress 3.x? [duplicate]
23. Get a button for in the Editor
24. Disabling Comment Notifications for Post Author
25. Some way to Flush or Overwrite all Imported Content in a Site for a Fresh Import – How?
26. Notify commenters about new replies
27. Don’t send notification if author comments his own post plugin help?
28. Thumb rating for wordpress – top user
29. Image Crop/Resize Function/Code Sinppet/Plugin to adjust/crop images during upload
30. WP get_permalink Return Wrong URL
31. How to add product images using script?
32. Fatal error: Uncaught Error: Call to undefined function get_userdata()
33. Setting up widgets in wordpress with a unique ID for the after_title argument
34. How to add a privacy-checkbox in comment-template?
35. MailChimp integration that allows users to select from multiple lists [closed]
36. Distributing and packaging plugins
37. Use plugin or custom post type for game score functionality
38. How to Replace Words with Hypertext Link But Ignore Previously Existed Links?
39. Copyright messages for a particular set of pages
40. Display comments of users on single page
41. WordPress logo upload option in theme panel
42. how to load the language file in plugin?
43. Accessing post’s meta data based on user’s click of a post
44. View Private Published Page with URL Code (no login required)
45. Get posts from WP_Query and format them on admin_head
46. How to query the custom fields by language?
47. Translating long texts with html formatting
48. Does any one have Idea to get these functionalities with the plugin wp-multi-network
49. custom payment gateway in woocommerce failed to connect to remote api server
50. How to call WordPress function other files
51. Insert content of a post into another
52. WP_Query and NULL meta keys
53. $wpdb->get_row returns column name instead of column value
54. Anspress Customization: How to show logged in user votes on a single answer?
55. Create a table with wordpress plugin boilerplate
56. WordPress page and plugin list using sql query
57. How create Group Blogs based on user created Groups
58. Custom table naming/access convention for multisite: $table_prefix vs base_prefix or other?
59. date/time-picker and file upload (image) fields for custom fields (e.g. with more fields)
60. plugin code is pulling information from database in one instance and not in other. What is wrong?
61. allow photo/video in comments
62. Inserting custom PHP script on homepage
63. Best practice for including plugin output in a template without using shortcode?
64. a weird attribute on every html tag
65. order posts by `meta_key`, Does not display posts that does not have `meta_key`
66. How to change the wp_upload_dir() path in plugin
67. Disable plugin only for one post
68. woocommerce search by sku and title ajax
69. Advanced WordPress plugin activation detection
70. how to change wp-admin url using function file
71. Calling a save function from a “submit” button
72. Is there a way to easily manage Project options (custom-fields)
73. Renaming Custom Taxonomy Values
74. Add a “default sorting” menu to child store pages
75. Plugin code will not work properly inside a class [closed]
76. Custom Module, Extending WP with a Plugin?
77. Rename Smart YouTube’s httpv back to http for all posts
78. WordPress FLIR (Facelift Image Replacement) plugin clipping off end of text
79. How to make PDF books readable on site with woo-commerce?
80. Adding category base to url in custom post giving 404?
81. How Can I Increase Breadcrumb Position Count (Starting From 2)?
82. How to get a specific string from a url
83. Add custom WordPress admin page with pretty url via code
84. WooCommerce Product Table – filter query on attributes
85. Why does plugin_url append absolute file path?
86. Move plugin upload folder from mywebsite.com/wp-content/uploads/pdfuploads to mywebsite.com/pdfs?
87. Custom Icon assigned to menu items not working for multi-site networks
88. Woocommerce list variations that are added already to cart in Single Product
89. Share on social media created listing after submission
90. Translation plugin with default language?
91. Custom pages with plugin
92. Changing the body of mail sent to new user registration
93. Which One Is Better For Managing Add Ons For Extensible Plugin?
94. Posts are deleted everyday at night
95. WordPress Code Access to Restricted Content without Registration
96. What can I do to customize a widget provided with this plugin? from where have I to start?
97. $wpdb selects wrong database
98. Questions about using Disqus or Jetpack for comments [closed]
99. How to pre-set WordPress settings for specific posts?
100. How to Add Extra Text In WordPress Title Before Post Publish