> Le 18 juil. 2016 à 14:07, Olivier Mascia <o...@integral.be> a écrit :
> 
> is there common knowledge here about how page allocation is decided?
> 
> Let's say we have a database with page_size set to 16 KiB.
> What will happen when inserting a row whose encoded weight is, for instance, 
> 3 KiB and the btree content would lead to store it on a page where about 2 
> KiB are still unused?
> Will SQLite fill in the page and use some overflow page for the remaining 
> bits or will a new page get used?
> 
> I'm sorry if I missed a documentation page explaining this.  I suppose there 
> is, but couldn't find it.

I found the page I missed: https://www.sqlite.org/fileformat.html
How did I skipped it until now is unknown. :)

-- 
Meilleures salutations, Met vriendelijke groeten, Best Regards,
Olivier Mascia, integral.be/om



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

Reply via email to