yes, i agree except that the file fragmentation of the file database cause also the file fragmentation of some other files... that is logique when more than 2 file grow a little at a time ! and the other file need absolutely to not be fragmented !
On 12/11/2010 12:07 AM, Max Vlasov wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
