{
  "$type": "site.standard.document",
  "bskyPostRef": {
    "cid": "bafyreih6ppmvgpirfhfgretfroje2o73qjaqqsekpfjatkibd4ub5gzsda",
    "uri": "at://did:plc:pvz7ox4x2ehjiezsahttqyyz/app.bsky.feed.post/3meqxhdx54ic2"
  },
  "path": "/viewtopic.php?p=449512#p449512",
  "publishedAt": "2026-02-13T16:21:10.000Z",
  "site": "https://forum.luanti.org",
  "tags": [
    "https://sqlite.org/compile.html",
    "https://www.usenix.org/system/files/fast22-oh.pdf",
    "Hybrid Dog"
  ],
  "textContent": "Maybe it's possible to use sqlite's compile time options for a performance gain.\nWith F2FS, sqlite's SQLITE_ENABLE_BATCH_ATOMIC_WRITE compile time option should work, which can make transactions over twice as fast, while simultaneously reducing wear on SSD storage devices.\nFurthermore, if supported by the file system, the SQLITE_ENABLE_ATOMIC_WRITE option can result in significant speed improvements for small updates.\nhttps://sqlite.org/compile.html\n\nThere also exists exF2FS, which improves the SQLite performance by 24× against stock SQLite and reduces the write volume to 1/6 compared to the PERSIST\njournal mode of SQLite.\nhttps://www.usenix.org/system/files/fast22-oh.pdf\n\nStatistics: Posted by Hybrid Dog — Fri Feb 13, 2026 16:21\n\n* * *",
  "title": "General Discussion • SQLITE_ENABLE_BATCH_ATOMIC_WRITE",
  "updatedAt": "2026-02-13T16:21:10.000Z"
}