Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Enhancement: Full sync query is slow on larger sites #41092

Open
joshuatf opened this issue Jan 15, 2025 · 1 comment
Open

Enhancement: Full sync query is slow on larger sites #41092

joshuatf opened this issue Jan 15, 2025 · 1 comment
Labels
[Boost Feature] Optimizations [Boost Feature] Page Cache [Experiment] AI labels added [Feature Group] Content Management Features related to the tools and screens that admins use to manage their sites core content. [Focus] Performance [Plugin] Boost A feature to speed up the site and improve performance. [Type] Enhancement Changes to an existing feature — removing, adding, or changing parts of it

Comments

@joshuatf
Copy link
Contributor

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

Image
@joshuatf joshuatf added [Focus] Performance [Type] Enhancement Changes to an existing feature — removing, adding, or changing parts of it labels Jan 15, 2025
This was referenced Jan 15, 2025
Open
Open
@github-actions github-actions bot added [Plugin] Boost A feature to speed up the site and improve performance. [Boost Feature] Optimizations [Boost Feature] Page Cache [Feature Group] Content Management Features related to the tools and screens that admins use to manage their sites core content. labels Jan 15, 2025
@github-actions GitHub Actions
Copy link
Contributor

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
[Boost Feature] Optimizations [Boost Feature] Page Cache [Experiment] AI labels added [Feature Group] Content Management Features related to the tools and screens that admins use to manage their sites core content. [Focus] Performance [Plugin] Boost A feature to speed up the site and improve performance. [Type] Enhancement Changes to an existing feature — removing, adding, or changing parts of it
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@joshuatf