With the release of version 27.8, Yoast SEO has introduced new performance optimizations that significantly reduce loading times, particularly for large websites with high volumes of content and users. This update optimizes database queries, lightens heavy operations in the dashboard, and reduces the plugin's overall footprint across the site.
What Changed and What Are the Technical Improvements?
The release focuses on redesigning features that previously caused scalability issues and consumed heavy system resources. One of the most critical technical changes was implemented to reduce the loading time of the root sitemap, especially on multi-author sites.
In the previous version, the `get_users()` function utilized a capability check (`capability` => `edit_posts`) to determine which users to include in the author sitemap. This triggered heavy MySQL queries containing `LIKE '%...%'` conditions that failed to utilize indexes and involved numerous JOIN operations. The new version replaces this approach with a leaner query structure that directly targets users who have published posts, bypassing the capability check. Additionally, operations that increased the operational load on sites with massive content libraries within the admin panel were streamlined, and the number of database round-trips was reduced.
Industry Implications and Code Quality
Large-scale websites and corporate structures frequently encounter bottlenecks in SEO performance due to database load and sluggish sitemap generation times. Targeted optimization updates of this nature enhance crawl efficiency for search engine bots while directly supporting the overall user experience. For developers and site administrators, such codebase improvements allow for much more efficient use of server resources.
Frequently Asked Questions
Which types of websites will benefit the most from this performance update?
While the update aims to speed up all sites in general, large-scale websites with thousands of pieces of content and numerous user accounts (such as authors and editors) will notice the improvements in loading times most distinctly.
Do the changes to backend database queries require any additional configuration for site administrators?
No, these optimizations are internal developments made within the plugin's codebase. Site administrators do not need to make any manual adjustments; the improvements take effect automatically following the update.
*This news article was prepared based on data published by the Yoast SEO Blog.
💬 Comments
No comments yet. Be the first!
You must be logged in to comment.
🔑 Log In