]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Re-use deleted rowids for new segments. This has a somewhat
authorshess <shess@noemail.net>
Mon, 11 Sep 2006 21:39:21 +0000 (21:39 +0000)
committershess <shess@noemail.net>
Mon, 11 Sep 2006 21:39:21 +0000 (21:39 +0000)
commit4240240f1218a304ddc14e76d321ff0529a9491e
tree800cd7711c08295ddf419b5b08ba54ed6465f38d
parent66b224cbb066b6ba4ebce027ecf643f6904b2a54
Re-use deleted rowids for new segments.  This has a somewhat
surprising impact on performance, I believe because it keeps the index
smaller (by keeping rowids smaller), and also because it improves
locality in the table (deleting a row means we've already touched the
pages leading to that rowid). (CVS 3405)

FossilOrigin-Name: 2f5f6290c9ef99c7b060aecc4d996c976c50c9d7
ext/fts1/fts1.c
manifest
manifest.uuid