cityofaustin / cityofaustin/techstack
Speed up OfficialDocumentPages query
Open
Bug Reported
Content type: Official document
Joplin Alpha
Team: Dev
- Dominant language
- No language data
- Stars
- 11
- Forks
- 3
- PR merge metrics
- No merged PRs in 30d
Description
We don't have indexes on our `getOfficialDocumentsCollectionDocumentsQuery`, that's why it times out.
So we need to make this query more efficient, and add the appropriate (janisbasepage_ptr_id, -date) index in such a way that it gets picked up by graphql => django => sql.
Maybe we need a data loader thing. https://apirobot.me/posts/django-graphql-solving-n-1-problem-using-dataloaders
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.