On Fri, Dec 10, 2010 at 11:20 PM, Vander Clock Stephane < svandercl...@yahoo.fr> wrote:
> Hello, > > to limit the file fragmentation i want to increase the size of the > database file (with the windows API function). > > Can i do this ? > > Vander, my tests show that the internal sqlite fragmentation affects more than the file system fragmentation. This is because when data placed naturally, the os predicts the data flow together with the client using the data, for internally fragmented db it's different, read this discussion http://www.mail-archive.com/sqlite-users@sqlite.org/msg56083.html (I gave a linke to my post since root message doesn't contain the full discussion for some reasons). So, VACUUM from time to time is better overall than Os defrag (imho) Max Vlasov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users