Taco Verdonschot on "[Plugin: Yoast SEO] Huge site, database server peak when creating sitemaps"

Hi team,

we run a huge site for a customer (>800.000 articles). The overall performance is fine. When Yoast creates the sitemap, the database server crashes due to slow queries caused by the Yoast sitemap module.

Check this graph: https://picload.org/image/rgrwclgl/yoast-xml-db-peak.png

Is this a familiar issue? Is there anything we can do to reduce the peaks?

Let me know if you need more information.

BR Dominik

https://wordpress.org/plugins/wordpress-seo/

Hi Dominik Ho,

This is something our development team would have to investigate. In order to do so, it'd be fantastic if you could create a ticket on GitHub describing this problem.
Please include every single bit of information you have.

Thanks a million!