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: |
d045f8b2d44e388d8c4549ff02d4ca7e |
| 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
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.