Enhancement: Full sync query is slow on larger sites

[joshuatf]

Impacted plugin

Boost

What

The full sync query could be optimized or cached

How

The full sync that seems to run on shutdown on some pages can be slow on larger sites. It may be a larger than average post table or a large number of post types that causes this.

This issue is reproducible on the WCCOM staging site on the WC status tools page.

Request URL: /wp-admin/admin.php?page=wc-status&tab=tools
Average query time: ~3.5s

[github-actions]

OpenAI suggested the following labels for this issue:

• [Feature Group] Content Management: The issue relates to the optimization of a query that impacts how content is managed on larger sites.
• [Boost Feature] Optimizations: The issue specifically mentions the need for optimization of the full sync query.
• [Boost Feature] Page Cache: Improving query performance often involves caching, which relates to page caching features.