On Mon, Apr 23, 2012 at 3:35 PM, Simon Slavin <[email protected]> wrote: > > For the second one, the simplest way to do something like defragment the data > inside the file is to use the VACUUM command:
Simon, thanks, I see what vacuum can do, sure I use it frequently as many of us. Ironically when I noticed the slowness, I did VACUUM that took almost a half an hour alone because the db contained other persistent data including big indexes. I think handling free list alone (for example allowing sort them only with a pragma) would help in cases like mine but unfortunately will add more confusion. Max _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
