On Tue, Sep 27, 2011 at 7:16 PM, Tim Streater <t...@clothears.org.uk> wrote:
> On 27 Sep 2011 at 18:15, Richard Hipp <d...@sqlite.org> wrote: > > > On Tue, Sep 27, 2011 at 1:13 PM, Tim Streater <t...@clothears.org.uk> > wrote: > > > >> The databases that get vacuumed tend to have a fair amount of traffic in > >> and out. So it's good to compress them from time to time. > > > > Really? Have you actually measured this to see if it makes a difference? > > What happens if you never VACUUM? > > They'll get bigger and bigger. I imagine the users (if I ever have any) > would start complaining. > You know that SQLite automatically reclaims and reuses space from rows you DELETE and tables you DROP, right? VACUUM repacks and defragments the database file. The repacking might make the file a little smaller, but probably not that much. Defragmenting might help performance, but again, probably not that much. Hence I ask: have you actually measured the difference? > > -- > Cheers -- Tim > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
