I’ve an internet site that has abruptly turn out to be sluggish. I do not know what triggered the change. I have never put in new plugins, and I do not assume I lately up to date any plugins. Upon inspection with Question Monitor, I can see that there are about 15,000 queries per web page. Many of the queries (14K+) are repeated queries to wp_options
SELECT option_name, option_value
FROM wp_options
WHERE autoload = 'sure'
Is the reason for these queries that sure rows which can be presupposed to have autoload=’sure’ don’t? How can I determine which rows ought to have autoload ‘sure’ vs ‘no’
I attempted copying the autoload ‘sure’ values from one other web site, and I used to be capable of decrease the full variety of queries to eight.5K like this. Nonetheless the web site is not any sooner.
Any recommendation on debugging this challenge or one way or the other “resetting” the autoload values of the wp_options desk?
