Re: [sqlite] Setting initial database size.

2012-09-02 Thread Mohit Sindhwani
Hi Roger On 1/9/2012 10:46 PM, Roger Binns wrote: 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. This tea

Re: [sqlite] Setting initial database size.

2012-09-01 Thread Simon Slavin
On 1 Sep 2012, at 3:46pm, Roger Binns wrote: > What tool did you use to work out that this is a problem? Actually I've done it myself on a handsized device which didn't have good error testing. It had an 8 Meg SD card and various other parts of the system would simply crash if they ran out o

Re: [sqlite] Setting initial database size.

2012-09-01 Thread Roger Binns
-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 u

Re: [sqlite] Setting initial database size.

2012-09-01 Thread Mohit Sindhwani
Hi Kjell, On 31/8/2012 8:28 PM, kjell.gunnars...@sungard.com wrote: Hi, 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). I have never seen any thing that sugges