DB Slow down after WordPress Update
-
Hello,
After updating wordpress, website takes 10-12 second to fully load, as i checked these are the queries which are taking all the time to load. I checked and created index as well. but nothing is working for now. Please guide me for the solution.
One all them is this and rest are same with different filters in WHERE
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) WHERE 1=1 AND ( wp_postmeta.meta_key = 'start_date' AND ( ( mt1.meta_key = 'end_date' AND mt1.meta_value > '20210827' ) OR ( ( mt2.meta_key = 'end_date' AND mt2.meta_value = '20210827' ) AND ( mt3.meta_key = 'end_time' AND mt3.meta_value > '05:25:08' ) ) ) ) AND wp_posts.post_type = 'events' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC, wp_posts.post_date DESC LIMIT 0, 2
Regards
Rajat Sharma
Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
- The topic ‘DB Slow down after WordPress Update’ is closed to new replies.