Skip to content

fix: improve performance of SQL query in the user loader#3183

Merged
jasonbahl merged 8 commits intowp-graphql:developfrom
jasonbahl:fix/3178-slow-query-in-user-loader
Aug 8, 2024
Merged

fix: improve performance of SQL query in the user loader#3183
jasonbahl merged 8 commits intowp-graphql:developfrom
jasonbahl:fix/3178-slow-query-in-user-loader

Conversation

@jasonbahl
Copy link
Copy Markdown
Collaborator

What does this implement/fix? Explain your changes.

This improves the performance of the SQL query in the User Loader that checks whether a user is considered a published author.

Does this close any currently open issues?

closes #3178

@coveralls
Copy link
Copy Markdown

coveralls commented Aug 5, 2024

Coverage Status

coverage: 84.172% (-0.002%) from 84.174%
when pulling e827217 on jasonbahl:fix/3178-slow-query-in-user-loader
into 4fcb1b1 on wp-graphql:develop.

Comment thread src/Data/Loader/UserLoader.php Outdated
…of post_author table as most sites have fewer users than posts so this requires less compute to complete
- update tests to WordPress 5.9
@qlty-cloud-legacy
Copy link
Copy Markdown

Code Climate has analyzed commit e827217 and detected 0 issues on this pull request.

View more on Code Climate.

@jasonbahl jasonbahl merged commit 33708fe into wp-graphql:develop Aug 8, 2024
This was referenced Aug 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Slow query in User Loader when querying for the public users

3 participants