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
Labels
A-Performance
Performance, both client-facing and admin-facing
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.
The text was updated successfully, but these errors were encountered: