Tribler / tribler

Privacy enhanced BitTorrent client with P2P content discovery
https://www.tribler.org
GNU General Public License v3.0
4.8k stars 444 forks source link

Move public_key and infohash into a separate table #4348

Open ichorid opened 5 years ago

ichorid commented 5 years ago

At this moment, public_key and infohash fields are stored in full for each entry. This adds unnecessary storage overhead and slows down every operation with the DB. So, these should be moved to separate tables. Unfortunately, this modification will require breaking the DB schema, as well as changing the REST endpoints interface a bit.

ichorid commented 3 years ago

This looks much more into @kozlovsky 's knowledge domain, this passing the responsibility