I have a (very) large table mit >100M rows. I want to delete 1M rows with some condition without running in any table lock or timeout issue.
IMO delete with limit is best choice in this case.
I'm trying to find a peewee equivalent for a simple sql query
DELETE FROM users WHERE condition=1 LIMIT 10
My first approach is:
but DeleteQuery doesn't have a limit method. oops...
So, what is best practice to delete a huge number of rows with peewee?