Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-11 Thread Simon Slavin
On 11 Dec 2010, at 8:18am, Vander Clock Stephane wrote: > 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 ? Fragmentation does not make much difference in any operating

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-11 Thread Vander Clock Stephane
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< >

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Max Vlasov
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

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Vander Clock Stephane
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

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Vander Clock Stephane
but i try and it's seam to work ? i simply increase manually the size of the database and it's seam to work ??? can you confirm that it's not possible because here it's work ? > Wait until your data file is large enough, then use any OS tool to > defragment it :) that a big mistake, because

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Max Vlasov
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

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Scott Hess
On Fri, Dec 10, 2010 at 12:20 PM, Vander Clock Stephane wrote: > to limit the file fragmentation i want to increase the size of the > database file (with the windows API function). Consider http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html . -scott

Re: [sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Dagdamor
Vander Clock Stephane писал(а) в своём письме Sat, 11 Dec 2010 02:20:42 +0600: > 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 ? > > thanks you by advance > stéphane Not

[sqlite] Increase the datafile file size to limit the file fragmentation

2010-12-10 Thread Vander Clock Stephane
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 ? thanks you by advance stéphane ___ sqlite-users mailing list sqlite-users@sqlite.org