I know this trick, but it's a little longer to do than simply manually increate the file DB size ? my test show it's work, i m just currious why we can not do like this ?
thanks again stéphane On 12/11/2010 3:44 AM, Max Vlasov wrote: > On Sat, Dec 11, 2010 at 1:52 AM, Vander Clock Stephane< > svandercl...@yahoo.fr> wrote: > >> 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 ! >> >> > Ok then, if you feel you need this, there's a trick for db expanding. Create > something big, like a table filled with random or uniform data and then > delete it, you will get a database file with plenty of free space. > > Max > _______________________________________________ > 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