Title: Slow query problem
Last modified: August 31, 2016

---

# Slow query problem

 *  [k0c1](https://wordpress.org/support/users/k0c1/)
 * (@k0c1)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/slow-query-problem-1/)
 * Hallo,
 * I have instal woocommerce + yoast seo , and my MySQL Databaze report Slow Query
   please fix, her is report from log:
 * # Query_time: 4.848047 Lock_time: 0.000028 Rows_sent: 0 Rows_examined: 574724
   
   use hmlm95nx; SET timestamp=1454396620; DELETE FROM wp_options WHERE option_name
   LIKE ‘_transient_wpseo_sitemap_cache_shop_order_%’ OR option_name LIKE ‘_transient_timeout_wpseo_sitemap_cache_shop_order_%’;#
   Time: 160202 8:03:46
 * [https://wordpress.org/plugins/wordpress-seo/](https://wordpress.org/plugins/wordpress-seo/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [webaware](https://wordpress.org/support/users/webaware/)
 * (@webaware)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/slow-query-problem-1/#post-7017306)
 * FYI wp-seo: the underscore character is a one-character wildcard in SQL. You 
   need to escape that sucker if you want to utilise an index on wp_options, otherwise
   you get a full table scan and can run into exactly this problem.
 * `LIKE '\_transient\_wpseo\_sitemap\_cache\_shop\_order\_%'`
 * etc.
 * cheers,
    Ross
 *  [tom](https://wordpress.org/support/users/klickchoice/)
 * (@klickchoice)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/slow-query-problem-1/#post-7017307)
 * so where i need to change this ? .Could you please advice ?. Need to write a 
   new function or change the code in plugin ?
 * Really thank you for your support 🙂
 *  [webaware](https://wordpress.org/support/users/webaware/)
 * (@webaware)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/slow-query-problem-1/#post-7017312)
 * G’day tom,
 * That’s something the Yoast SEO crew need to address in their code.
 * cheers,
    Ross
 * /cc [@tacoverdo](https://wordpress.org/support/users/tacoverdo/)
 *  [Taco Verdonschot](https://wordpress.org/support/users/tacoverdo/)
 * (@tacoverdo)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/slow-query-problem-1/#post-7017313)
 * Please feel free to write a [full bug report](http://yoa.st/bugreport) on [GitHub](https://github.com/Yoast/wordpress-seo/issues).
 * The better you’re able to describe the issue and all your findings, the bigger
   chances are that our development team is able to solve this.
 * Thanks for your help!
 *  [ronmisely](https://wordpress.org/support/users/ronmisely/)
 * (@ronmisely)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/slow-query-problem-1/#post-7017321)
 * But could you please check the given error , and the possibility or reason for
   this error ?

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Slow query problem’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

## Tags

 * [Yoast](https://wordpress.org/support/topic-tag/yoast/)

 * 5 replies
 * 5 participants
 * Last reply from: [ronmisely](https://wordpress.org/support/users/ronmisely/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/slow-query-problem-1/#post-7017321)
 * Status: not resolved