On 5/4/15, Mayank Kumar (mayankum) <mayankum at cisco.com> wrote: > 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 ? >
Many filesystems operate faster when disk access is sequential. See the last paragraph at https://www.sqlite.org/draft/dbstat.html for information on measuring how sequential your database file actually is. We would very much like to hear from you if you make any actual measurements of performance improvements after running VACUUM. So much depends on the OS and the underlying hardware that it is difficult to make general statements. But case studies are still useful. -- D. Richard Hipp drh at sqlite.org
