Regarding: My question is, when I insert new data, is the needed space allocated out > of the free_list or do the db file grows larger and the free space stays > till vacuum operation is performed? > Basically, my question is: on intensive inserts and deletes will the freed > space be re-used ? > > ========= >
Yes, new items are allocated from the freed list. For many applications vacuum will seldom be needed. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users