I am using Jffs2 file system. As of now I using all default from sqlite3.I am not sure with this information it is possible to get some approx that with 'X KB data, database file size will be 'Y' KB or MB.
> Regarding default file size. I understand with the use of max_page_count & size of each page database file size is get calculated. What is default setting for max_page_count (I leanr Default for page is 1KB) Cheers - Techi On 8/29/13, Simon Slavin <slav...@bigfraud.org> wrote: > > On 29 Aug 2013, at 9:11am, techi eth <techi...@gmail.com> wrote: > >> 1) Is their any way I can calculate approx file size based on data. >> >> Ex : Let us say i am creating table with (row ID int ,Test Text). >> >> Each text string size is 10 byte. If I will create 100 row of this in >> database then what would be Max size of created database file. > > Assuming that you are talking about a database file created from scratch, > you might be able to take a guess at the maximum file size by just creating > a file like that yourself and seeing how bit it is. But the answer for your > users would depend on which file system and which operating system they are > using. This is because those things govern the page size selected by > SQLite: > > <http://www.sqlite.org/pragma.html#pragma_page_size> > > You would have to allow so much 'slop' it might be easier just to pick an > acceptable number -- say half a megabyte, and use that. > >> 2) How do I can fix the database file size to make sure I have not >> exceeded >> max page count? >> >> http://www.sqlite.org/pragma.html#pragma_max_page_count > > No need. SQLite will itself refuse to make a database file bigger than > that. I believe it generates an SQLITE_IOERR for the command that tries to > exceed that page count. > > Simon. > _______________________________________________ > 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
