Alex Gleason 🐍 on Nostr: BTW my solution to insert performance (aside from the obvious ones like rate limiting ...

BTW my solution to insert performance (aside from the obvious ones like rate limiting and blocking Amethyst draft events), is to upsert instead of delete and create. This results in a huge performance improvement for things like giant follow lists.