Hi,
we store proprietary organized data in blobs within an sqlite database.
Assume you have a table mydata(id, attr1, attr2, blob).
The page size of the database is 1k.
If you now store blobs in your table which are larger than 1k,
sqlite uses overflow pages and the content of the blobs is distributed
to several pages, right? Are the pages on which the blobs are stored
consecutive or can they be distributed arbitrarily within the database file?
Can two records share the same overflow page, or is an overflow page dedicated
to one record?
Is there a formal definition of the fragmentation value which is reported by
sqlite3_analyzer?
Best Martin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
