Database files size:

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.

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

Cheers -

Techi
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to