element-hq / element-hq/synapse
Consider storing events as pickled binary blobs in the DB
Open
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
Assessment
This issue has not been assessed yet.