HomePhabricator
Diffusion Comm c26e02edac68

[keyserver] Look up uploads for a message using the container column

Description

[keyserver] Look up uploads for a message using the container column

Summary:
This is the second part of the stack to resolve ENG-1484, and is the core of it. This approach has *way* better performance.

Depends on D4673

Test Plan: I first tested this stack locally in my environment to make sure the queries worked. Then I patched it onto my production keyserver and confirmed performance was improved

Reviewers: tomek, atul

Reviewed By: tomek

Subscribers: adrian, abosh

Differential Revision: https://phab.comm.dev/D4674

Details

Provenance
ashoatAuthored on Jul 28 2022, 10:40 PM
Reviewer
tomek
Differential Revision
D4674: [keyserver] Look up uploads for a message using the container column
Parents
rCOMM881ac1b3ec75: [keyserver] Add index to container column of uploads table
Branches
Unknown
Tags
Unknown