Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Fix typo in the LSM documentation.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2016-07-28 13:44:05|
|15:49||Update the README into a README.md and clearly state that work on SQLite4 has concluded, lest there be any doubt. check-in: c0b7f14c09 user: drh tags: trunk|
|13:44||Fix typo in the LSM documentation. check-in: c2d3bd7694 user: drh tags: trunk|
|18:03||Fix typo in comments. No code changes. check-in: 7df97b5937 user: drh tags: trunk|
Changes to www/lsmusr.wiki.
1320 1320 the following are true: 1321 1321 1322 1322 <ul> 1323 1323 <li> <p>All database content is stored in a single 1324 1324 <a href=#architectural_overview>segment</a>. This makes the 1325 1325 data structure equivalent to an optimally packed b-tree stucture 1326 1326 for search operations - minimizing the number of disk sectors that need 1327 - to be visted when searching the database. 1327 + to be visited when searching the database. 1328 1328 1329 1329 <li> <p>The database file contains no (or as little as possible) free space. 1330 1330 In other words, it is no larger than required to contain the single 1331 1331 segment. 1332 1332 </ul> 1333 1333 1334 1334 <p>In order to optimize the database, lsm_work() should be called with ................................................................................ 1342 1342 1343 1343 <p>When optimizing the database as above, either the LSM_CONFIG_AUTOCHECKPOINT 1344 1344 parameter should be set to a non-zero value or lsm_checkpoint() should be 1345 1345 called periodically. Otherwise, no checkpoints will be performed, preventing 1346 1346 the library from reusing any space occupied by old segments even after their 1347 1347 content has been merged into the new segment. The result - a database file that 1348 1348 is optimized, except that it is up to twice as large as it otherwise would be. 1349 - 1350 - 1351 -