Is SQLITE_FCNTL_CHUNK_SIZE what you are looking for? See more information about it here: http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html. Notice that this feature appeared only in recent version of SQLite, so if you have some earlier version you won't be able to control it and SQLite will grow/shrink database page-by-page (maximum page size is 32Kb).
Pavel On Tue, Feb 22, 2011 at 7:28 AM, Sven L <larvpo...@hotmail.se> wrote: > > Can't seem to find a setting to control how the database file grows when > full. Is there such a setting? > It looks like the file increases by some < 100 kB when it is full. I want to > change this to around 10 MB (or even more) to avoid file fragmentation. > > Any ideas? > > Thanks > _______________________________________________ > 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
