Sqlized communities to greatly optimize sync

Massively move python code into PGSQL functions to centralize many queries into single one and avoid re-querying the same data.

some benchmarks:

UpdateProps (20k ops):
develop: 14.6382s
branch:  7.2957s

setRole (20k ops):
develop: 26.6091s
branch:  19.3401s

mute + unmute (20k ops):
develop: 34.7600s
branch:  21.1183s
Edited by Howo

Merge request reports

Loading