michael1011 on Nostr: Are you deleting all data in the table? Use TRUNCATE Else see what SQLite tells you ...

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