I know and have used deframentation apps. Thats good. But why to force end-users to defragment their disk.
SQLite manages free-space in file very-well (after deleting records). So I also created one template database file with optimum number of records, then deleted records and copied that file while creating new company db file. But like some other Databases, if SQLite does provide any way to set auto-increment for database file by some fixed percentage (say 20%, 40% etc.) such that everytime database file reaches some threashould size it automatically add free space, that will reduce file defragmentation. What are your thoughts on that ? Rohit -- View this message in context: http://www.nabble.com/Avoiding-Fragmentation-of-SQLite-database-file-----t1780629.html#a4862560 Sent from the SQLite forum at Nabble.com.