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 <av201...@yahoo.com> 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 <mdipie...@cs.depaul.edu> wrote:
>
>
>
> > should this be default?
>
> > On Sep 29, 5:56 am, rochacbruno <rochacbr...@gmail.com> wrote:
>
> > > db.executesql('PRAGMA auto_vacuum = X') ?
>
> > > Enviado via iPhone
>
> > > Em 29/09/2010, às 06:01, winti <stefan.winterb...@gmail.com> 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 -
