Skip to content
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was 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

@erikjohnston

Description

@erikjohnston

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-PerformancePerformance, both client-facing and admin-facing

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions