SQLite

Check-in [d045f8b2d4]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | sorter-coalesce-writes
Files: files | file ages | folders
SHA1: d045f8b2d44e388d8c4549ff02d4ca7eff4e2038
User & Date: dan 2012-08-06 18:50:11.492
Context
2012-08-06
19:12
Fix a crash that could follow an OOM condition. (Closed-Leaf check-in: 2e5741f774 user: dan tags: sorter-coalesce-writes)
18:50
When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. (check-in: d045f8b2d4 user: dan tags: sorter-coalesce-writes)
18:10
Update sorter-coalesce-writes branch with latest trunk changes. (check-in: 214f8cda17 user: dan tags: sorter-coalesce-writes)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/analyze.c.
Changes to src/btree.c.
Changes to src/btree.h.
Changes to src/btreeInt.h.
Changes to src/build.c.
Changes to src/sqliteInt.h.
Changes to src/test_vfs.c.
Changes to src/vdbe.c.
Added test/index5.test.