In my current project i am temporary storing blob's. In this case the
vacuum feature helps a lot to reduce overhead.
in my case i can reduce the growing sqlite db file's from 600MB to
200KB while using:
db.executesql('PRAGMA auto_vacuum = FULL')
db.executesql('VACUUM')Thanks Stefan On 29 Sep., 17:34, Anthony <[email protected]> wrote: > "Note, however, that auto-vacuum only truncates the freelist pages > from the file. Auto-vacuum does not defragment the database nor repack > individual database pages the way that the VACUUM command does. In > fact, because it moves pages around within the file, auto-vacuum can > actually make fragmentation worse." > > We might want to consider the above before making auto_vacuum the > default. > > Even without auto_vacuum, the database does eventually reclaim free > space by reusing it for subsequent inserts. So, perhaps auto_vacuum is > not so important unless you're regularly deleting large amounts of > data and not replacing it very quickly (otherwise, a periodic VACUUM > might be adequate). > > Anthony > > On Sep 29, 9:43 am, mdipierro <[email protected]> wrote: > > > > > should this be default? > > > On Sep 29, 5:56 am, rochacbruno <[email protected]> wrote: > > > > db.executesql('PRAGMA auto_vacuum = X') ? > > > > Enviado via iPhone > > > > Em 29/09/2010, às 06:01, winti <[email protected]> escreveu: > > > > > Hello, > > > > is there a way to reclaim free space in sqlite db's within web2py as > > > > described here: > > > > >http://www.sqlite.org/pragma.html#pragma_auto_vacuum > > > > > Stefan- Hide quoted text - > > > - Show quoted text -
