On 11 Feb 2012, at 10:06pm, Orit Alul wrote: > When deleting from sqlite, the freed space is added to the free_list count. > 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 ?
SQLite uses available free space first. Only if there is no free space will it make the database file bigger. (This isn't quite accurate but it's mostly correct.) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
