Skip to content

activitypub utils: optimize block and follow activity lookup

kaniini requested to merge kaniini/pleroma:bugfix/follow-query-overhead into develop

multi-field @> comparison is very expensive, so only use @> for the field where it matters.

this makes the query take only a few usec to execute verses many msec on a busy instance.

Merge request reports