Hi All I am thinking about measuring the performance of sqlite3 write transactions after lot of delete transactions have been performance but vacuum has not been performed versus when vacuum is performed. Wanted to get some ideas here on what people think theoretically should happen. I know it reclaims free pages, but would this give a dramatic increase in write/update transactions ?
-mayank