element-hq / element-hq/synapse

Consider storing events as pickled binary blobs in the DB

Open
#12,959 0 comments 0 reactions 0 assignees View on GitHub
A-Database T-Enhancement
Dominant language
Python
Stars
4.6k
Forks
600
Avg merge
5d 22h
Merged PRs (30d)
51

Description

This issue has been migrated from [#12959](https://github.com/matrix-org/synapse/issues/12959).

---

Folklore has it that Synapse spends a lot of time parsing json from text columns in the DB. It might be quicker to store and load a pickled version of the event. The event content is already an opaque blob AFAIK; I'm not sure we'd lose much by making an opaque binary blob rather than an opaque text blob. The first step would be to make some kind of vaguely representative benchmark and see how long depickling takes compared to parsing.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.