search

bartervg / barter.vg

Track and hold discussion on Barter.vg bugs, enhancements, and other issues
https://barter.vg
MIT License
20 stars 4 forks source link

Proposal: Deleting some types of feed activity items #307

Open bartervg opened 1 year ago

bartervg commented 1 year ago

Which feed activity is useful? Which can be safely deleted?

It may not be worth the resources to save everything indefinitely. It is easier to maintain and optimize a smaller database.

What is the feed activity?

After years of accumulation, the database contains over 20GB of feed data.

A feed activity item looks like

+ ellipsism added Item for testing purposes 1 to Bundle for testing purposes 84 minutes ago

The largest category with 20 million rows is the removing / moving collection items

5 seconds ago ellipsism moved Writers from Blacklist

A large and not seemingly useful type is automatically synced. Recent syncs maybe, but not years of sync activity.

arseny92 commented 1 year ago

Bundle postings and corrections may still be useful. Moves, removes in user collections and sync activity not so much.

ialarmedalien commented 1 year ago

I'm only interested in "official" barter.vg activity, e.g. bundle postings. The rest is just noise.