Dear all, I know the source code study will bring me answers. I know experimentation could do so more or less. But 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. So much thanks for pointers or definitive answers. :) -- 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
