Hello! On Wednesday 04 March 2009 04:44:05 D. Richard Hipp wrote: > One could envision future versions > of SQLite that allowed you to preallocate a large database files such > that the database always stayed less than 80% full. Then we could use > filesystem techniques to keep fragmentation down. The penalty, of > course, is that your database file is larger. Probably much larger. > And just to be clear: SQLite does not have that capability at this time.
Can enough cache size prevent fragmentation? And how to calculate degree of fragmentation and when is needed make vacuum of database? Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
