-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 31/08/12 05:28, kjell.gunnars...@sungard.com wrote: > Does somebody know if it's possible to set an initial database size > when the database is created ?. (A large file doesn't have to be > incremented in size when records are inserted).
You can use sqlite3_file_control. See: http://www.sqlite.org/c3ref/c_fcntl_chunk_size.html SQLITE_FCNTL_CHUNK_SIZE would be the most useful - set it to something you have measured as useful to your data patterns and filesystems. SQLITE_FCNTL_SIZE_HINT is implemented for the Unix (also used for Mac) and Windows VFS. What tool did you use to work out that this is a problem? Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAlBCH8QACgkQmOOfHg372QRBfACeNFKOniQ7ifSDmZMnLC0KTQbL Gy4AoORHiFi7bCJInxAN0pjM+ethHoFO =cDIX -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users