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.

0 files changed, 0 insertions, 0 deletions