SQLite Forum

Displaying progress state during DELETE execution
Login
> Is there any way to be called back, so that i can display a "percentage done" information during this running DELETE statement?

The only way to do a percentage, AFAIK, is to first collect and count the records, then delete them one at a time, but you can get a notification that "work is being done," with no indication of when it will end, using:

<https://www.sqlite.org/c3ref/progress_handler.html>