purifetchi / Toki

A C# Fediverse server.
GNU Affero General Public License v3.0
47 stars 1 forks source link

Refactor the mentions field for the Post table. #29

Closed purifetchi closed 3 days ago

purifetchi commented 2 months ago

For now we store redundant informations in the UserMention field in the Post table. It actually takes up a ton of space and would only pose problems the bigger the database grows.

We should instead just store the IDs of the users we've mentioned, a'la the Emoji field, and then fetch all of them in bulk when rendering the status.