diff options
| author | Matthew Hodgson <matthew@matrix.org> | 2016-09-26 01:18:41 +0100 |
|---|---|---|
| committer | Matthew Hodgson <matthew@matrix.org> | 2016-09-26 01:18:41 +0100 |
| commit | cc4944c83e25c3fd622d0d553a6d3fa585f18a47 (patch) | |
| tree | 96d09e4af8f9c6de90a29e190d373b87bbb87dda /syweb/__init__.py | |
| parent | typo (diff) | |
| download | synapse-matthew/speed-up-dedup.tar.xz | |
speed up state deduplication migrations on sqlite github/matthew/speed-up-dedup matthew/speed-up-dedup
Remove the self-inner-join and instead abuse sqlite's quirk that it allows us to mix aggregate & non-aggregate columns in a grouped select to return the event_ids of the events in a state group: see http://marc.info/?l=sqlite-users&m=141460824410980&w=2. This speeds up these queries by around 25x, drastically improving performance when sqlite is upgraded to 0.18.
Diffstat (limited to 'syweb/__init__.py')
0 files changed, 0 insertions, 0 deletions