Re: [sqlite] Loose auto_vacuum.

--- Scott Hess <[EMAIL PROTECTED]> wrote: > Recently, various incremental vacuum features have been added, so you can do: > > -- Turn on incremental vacuum. > PRAGMA auto_vacuum = incremental; > > -- Release 100 pages from the freelist, or all if there are fewer. > PRAGMA incremental_va

[sqlite] Loose auto_vacuum.

Recently, various incremental vacuum features have been added, so you can do: -- Turn on incremental vacuum. PRAGMA auto_vacuum = incremental; -- Release 100 pages from the freelist, or all if there are fewer. PRAGMA incremental_vacuum(100); -- Return the number of items on the freelist.