Hi, Continuing the following thread, I'd like to explain my question better: http://www.mail-archive.com/sqlite-users@sqlite.org/msg67668.html
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 ? Please advice, Thanks, Orit [Creative Zone by MediaMind]<http://feeds.mediamind.com/CreativeZone> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users