Hi,
i have been struggling with this specific query which is increase load on my server
i have about 11000 posts (and in bold section “POST ids” all seems to be there with ids)
What exactly i should do for it.
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID IN (POST ids...)\n) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 5
Please suggest
Hi,
You can search online for database related issues, you could find useful topics. I found this topic for example
– https://wpartisan.me/tutorials/wordpress-database-queries-speed-sql_calc_found_rows
Maybe your hosting provider can provide some advice as well.
