lbryio / lbrycrd

The blockchain that provides the digital content namespace for the LBRY protocol
https://lbry.com
MIT License
2.57k stars 178 forks source link

v17.4+ writes interior trie nodes to the takeover db #403

Open BrannonKing opened 3 years ago

BrannonKing commented 3 years ago

For example, see: select distinct name from takeover t where t.height = 658309 and name not in (select distinct nodeName from claim); It looks like one third of the nodes in the takeover table are invalid. It's a minor performance issue.