[sqlite] progress_handler: progress in percentage?

[weiyang wang]

hi,

i am looking into the sqlite3_progress_handler() and i am wondering the
possiblity of representing progress in percentage.

the period of progressing update is based on number of  virtual machine
opcodes, is there anyway that we can estimate the total amount of opcodes of
one query during the preparation stage so that the progress status could be
shown in percentage.

thanks in advance.