It will not relate to the number of bytes/pages to move. An example:
If I "explain vacuum"... 0|Trace|0|0|0||00| 1|Vacuum|0|0|0||00| 2|Halt|0|0|0||00| I count these rows to two (excluding halt). When running a lengthy operation the best resolution I can get is 50 percent. Unfortunately, this will not be informative to the user. Patrik On 05/05/2012 07:45 PM, Simon Slavin wrote: > > On 5 May 2012, at 6:18pm, Patrik Nilsson <nipatriknils...@gmail.com> wrote: > >> Is it possible to get the total number of virtual machine instructions a >> "begin... commit"-statement will need? I.e. progress of saving data to >> the database. > > Using 'EXPLAIN ...' for each of your instructions, and adding up the number > of rows in each answer might give you a useful number. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users