Delete transient from DB query taking a long time to resolve

  • Hi, I’ve been trying to figure out why my site seems to slow to a crawl when I make an ajax request to load more posts and I’ve narrowed it down to the:

    DELETE FROM wp_options WHERE option_name =

    query made by this plugin to delete Twitter transients. I took a look at my wp_options table and noticed it has 3,000+ rows of Twitter and Facebook transients with only ~20 posts on my site within 3 days.

    What can be done to fix how long these queries are taking and how many transients are being created in the wp_options table?

    Thanks!

    • This topic was modified 7 years, 11 months ago by prodo.
  • The topic ‘Delete transient from DB query taking a long time to resolve’ is closed to new replies.