On 18 Nov 2011, at 4:17pm, Sreekumar TP wrote: > And if the pages are defragmented heavily, new inserts could result in > database size increase until vacuum is performed.?
Yes, but new inserts always result in fragmentation unless there's a really weird coincidence. You're not adding more characters to the end of a text file, you're messing with pointers and linked lists and tree structures. It makes little difference whether the space you're inserting the data in was grabbed from free space last week or has to be freshly grabbed from free space. Fragmentation only matters a lot for Windows on hard disks anyway. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
