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

Investigate Area.metadata.leftRightIndex index #297

Closed
vnugent opened this issue May 21, 2023 · 1 comment
Closed

Investigate Area.metadata.leftRightIndex index #297

vnugent opened this issue May 21, 2023 · 1 comment

Comments

@vnugent
Copy link
Contributor

vnugent commented May 21, 2023

When reviewing PR #296 I happened to look at the area schema and thought the current index on leftRightIndex is incorrect (we're not just searching for a leftToRightIndex alone). It should be a compound index with both _id and metadata.leftRightIndex.

https://github.com/OpenBeta/openbeta-graphql/blob/develop/src/db/AreaSchema.ts#L120

To do:

  • add .explain('executionStats') and see how it affects sorting
@vnugent
Copy link
Contributor Author

vnugent commented Jan 4, 2024

#376

@vnugent vnugent closed this as completed Jan 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@vnugent