On Tue, Sep 27, 2011 at 7:16 PM, Tim Streater <[email protected]> wrote:
> On 27 Sep 2011 at 18:15, Richard Hipp <[email protected]> wrote: > > > On Tue, Sep 27, 2011 at 1:13 PM, Tim Streater <[email protected]> > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
