-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/07/12 05:29, Simon Slavin wrote: > Fragmentation of the database file on disk is something that SQLite > can't control,
However you can ask SQLite to do things that will mitigate fragmentation by extending the file in larger blocks. See the file controls, especially SQLITE_FCNTL_CHUNK_SIZE: http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk/1oosACgkQmOOfHg372QQSRACgglDh1oe9cL7Wm7ShbUYjDWdZ ONMAoJApn6aFivn9CtZiD66QIDJUn4md =t518 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users