Skip to content

Split database with reference tables #493

@mchangrh

Description

@mchangrh

An old idea by @grublets that I wanted to immortalize on the github

original proposal:
https://discord.com/channels/603643120093233162/603643205552177155/991928401298468957

  • Split sponsorTimes into static/ dynamic parts
  • dynamic values like votes, view, locked, hidden change frequently and quickly which updates the entire row
  • static values like userID, reputation, videoID and UUID are static and should never be changed

if both values can be split, then it would make replication a lot easier as the row update would contain a lot less data and especially for db downloads as the static data can be appended to without any worry of corrupting old entries and all the dynamic changed data is easily compressible since it's mostly integers or bits.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions