> 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