I’m deleting all rows where a specific column contains a specific string (removing events that spam scamming links from the relay db).
Are you deleting all data in the table? Use TRUNCATE https://www.sqlite.org/lang_delete.html
Else see what SQLite tells you in its query plan: https://www.sqlite.org/eqp.html
Hard to suggest optimizations without knowing what you are doing
I’m deleting all rows where a specific column contains a specific string (removing events that spam scamming links from the relay db).
