Stephen Chrzanowski wrote:
> On Thu, Aug 29, 2013 at 3:03 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
>> 3. auto_vacuum will increase fragmentation
>
> I thought it did a complete dump to a new file?

<http://www.sqlite.org/pragma.html#pragma_auto_vacuum> says:
| 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.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to