I am thinking to use auto_vacuum INCREMENTAL & PRAGMA incremental_vacuum(N) to make sure whenever required, pages can be free.
I assume this will be better option with compare to FULL. I assume i can do anytime this operation in squence after opening successfull connection to Database.I am holding open connection handler as long as i required in system. Thanks.. Cheers - Techi On 8/30/13, techi eth <techi...@gmail.com> wrote: > 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
