On 17 Mar 2016, at 7:34pm, Domingo Alvarez Duarte <sqlite-mail at 
dev.dadbiz.es> wrote:

> Hello I have an application that uses sqlite3_progress_handler to update a
> gui application and when we do a "vacuum" on a big database the gui get
> frozen

VACUUM gets translated into just one virtual machine instruction.  Since it's 
all one long instruction the progress handler can't see any breakdown of the 
many things it does.

Try EXPLAIN VACUUM to see what's going on.

Simon.

Reply via email to