Skip to content
Snippets Groups Projects
  1. Nov 18, 2011
  2. Nov 16, 2011
  3. Nov 07, 2011
  4. Oct 10, 2011
  5. Jul 13, 2011
  6. Jul 04, 2011
  7. Jun 27, 2011
  8. May 03, 2011
  9. Apr 11, 2011
  10. Feb 10, 2011
  11. Feb 09, 2011
  12. Feb 08, 2011
  13. Dec 17, 2010
  14. Dec 10, 2010
  15. Oct 29, 2010
  16. Oct 22, 2010
  17. Oct 04, 2010
  18. Aug 27, 2010
  19. Aug 12, 2010
  20. Aug 06, 2010
  21. Aug 04, 2010
    • Eelco Dolstra's avatar
      * Use SQLite 3.7.0's write-ahead logging (WAL mode). This is a lot · fd9c77df
      Eelco Dolstra authored
        faster than the old mode when fsyncs are enabled, because it only
        performs an fsync() when doing a checkpoint, rather than at every
        commit.  Some timings for doing a "nix-instantiate /etc/nixos/nixos
        -A system" after modifying the stdenv setup script:
      
          42.5s - SQLite 3.6.23 with truncate mode and fsync
           3.4s - SQLite 3.6.23 with truncate mode and no fsync
          32.1s - SQLite 3.7.0 with truncate mode and fsync
          16.8s - SQLite 3.7.0 with WAL mode and fsync, auto-checkpoint
                  every 1000 pages
           8.3s - SQLite 3.7.0 with WAL mode and fsync, auto-checkpoint
                  every 8192 pages
           1.7s - SQLite 3.7.0 with WAL mode and no fsync
      
        The default is now to use WAL mode with fsyncs.  Because WAL doesn't
        work on remote filesystems such as NFS (as it uses shared memory),
        truncate mode can be re-enabled by setting the "use-sqlite-wal"
        option to false.
      fd9c77df
  22. Jun 24, 2010
  23. Apr 19, 2010
  24. Mar 23, 2010
  25. Mar 11, 2010
  26. Mar 05, 2010
  27. Mar 02, 2010
  28. Feb 24, 2010
Loading