Skip to content
This repository has been archived by the owner on Apr 26, 2024. It is now read-only.

device_lists_stream table is large and gets queried a lot #5553

Closed
erikjohnston opened this issue Jun 25, 2019 · 0 comments
Closed

device_lists_stream table is large and gets queried a lot #5553

erikjohnston opened this issue Jun 25, 2019 · 0 comments
Labels
A-Performance Performance, both client-facing and admin-facing

Comments

@erikjohnston
Copy link
Member

device_lists_stream is one of the busiest tables in terms of number of rows fetched from it. This turns out to be because clients can ask us to do an unbounded fetch for all devices that have changed between two tokens, which returns a lot if the tokens are old.

We also store a row per device, but we don't actually seem to read the device.

@neilisfragile neilisfragile added A-Performance Performance, both client-facing and admin-facing p1 labels Jun 27, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
A-Performance Performance, both client-facing and admin-facing
Projects
None yet
Development

No branches or pull requests

2 participants