SQLite Forum

Displaying progress state during DELETE execution
Login
My Application upgrades archived LogBook dBase-files into a sqlite database. So that the resulting sqlite database will be sometimes >300MB...

After this import i have to delete some of the archived data:

e.g.
DELETE FROM LogBook_LID WHERE DATETIME(TimeStampUtc) < DATETIME('now', '-5 years')

This may take a long time (5 min or more - as transaction).

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