How to get SQLite 'VACUUM' Progress

Question

Is there a way to get the progress of sqlite 'VACUUM'?I am using this line of code here in Java:

connection1.createStatement().executeUpdate("VACUUM");

The User(MySelf & I) has to wait from some seconds to some minutes,i know that the actual .db file is being overriten with the help of a journal file that is created through the execution of the command.

Can i get an estimation using JAVA IO or something?Thanks for help..

Answer 1

No. The SQLite C API has a progress handler, but it's probably not exposed by your Java driver, and the vacuum processing is implemented with a different mechanism that does not report the progress anyway.

You could try to look at the current size of the database file and of any temporary files, but it is practically impossible to get the name of the latter.