Syncing a list asks for every account, and its subscription to the list, once per listed feed #377

New Issue

rays · 2026-10-25T09:02:07-07:00

rays commented

2026-10-25 09:02:07 -07:00

Found adding spans to the list sync (#372). sync_group in lists.rs subscribes the list's readers to each feed it lists with for id in list_and_feeds { for user in ctx.db.users().await? { if ctx.db.subscription(user.id, parent_id)... } }: the accounts and each one's subscription to the list are read again for every listed feed, though neither changes in the loop. A list of 922 feeds (davewiner's) with three accounts is about 3,700 queries a sync where four would do.

Found adding spans to the list sync (#372). sync_group in lists.rs subscribes the list's readers to each feed it lists with `for id in list_and_feeds { for user in ctx.db.users().await? { if ctx.db.subscription(user.id, parent_id)... } }`: the accounts and each one's subscription to the list are read again for every listed feed, though neither changes in the loop. A list of 922 feeds (davewiner's) with three accounts is about 3,700 queries a sync where four would do.

rays added the bug label 2026-10-25 09:02:07 -07:00

rays referenced this issue from a commit

2026-10-25 09:18:18 -07:00

Metrics and traces for what had none, and alerts on them (#365-#377)

rays commented

2026-10-25 09:35:56 -07:00

Fixed in dd91602: the readers of a list are read once a sync, not once per listed feed. Deployed 2026-10-25.

Fixed in dd91602: the readers of a list are read once a sync, not once per listed feed. Deployed 2026-10-25.

rays closed this issue

2026-10-25 09:35:57 -07:00

Sign in to join this conversation.