pubsubhubbub_topic_urls massive size and autoload=yes

Hi,

I noticed a lot of simple wp_options queries to our db started taking several seconds to return in the last few months and finally decided to analyze.

I found that by far the top offender, which is returned by all queries SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes' is pubsubhubbub_topic_urls.

This means every single page request loads this value and that much more data, unnecessarily. On one of our sites, the length is 2MB, on another 500KB.

But setting it to autoload=no apparently doesn’t get rid of the code accessing it on every page load either. Now I am seeing a separate query for SELECT option_value FROM wp_options WHERE option_name = 'pubsubhubbub_topic_urls' LIMIT 1 fire all the time instead.

This is a very taxing event on the network.

Can you please take a look? I don’t think there’s a need to access pubsubhubbub_topic_urls on every request to the site.

Thank you.