Replying to Avatar 0xtr

I’m deleting all rows where a specific column contains a specific string (removing events that spam scamming links from the relay db).
Avatar
t4es5ter5 2y ago

You tried setting index on that column?

Reply to this note

Please Login to reply.

Discussion

Avatar
0xtr 2y ago

That could probably make it more efficient but tbh, I don’t want to mess too much with the database itself as I expect the relay software to handle that. Don’t want to mess up an upgrade later on. Thanks for the suggestion though.