Skip to content
Snippets Groups Projects
  1. Jul 13, 2011
  2. Jul 04, 2011
  3. Jun 27, 2011
  4. May 03, 2011
  5. Apr 11, 2011
  6. Feb 10, 2011
  7. Feb 09, 2011
  8. Feb 08, 2011
  9. Dec 17, 2010
  10. Dec 10, 2010
  11. Oct 29, 2010
  12. Oct 22, 2010
  13. Oct 04, 2010
  14. Aug 27, 2010
  15. Aug 12, 2010
  16. Aug 06, 2010
  17. 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
  18. Jun 24, 2010
  19. Apr 19, 2010
  20. Mar 23, 2010
  21. Mar 11, 2010
  22. Mar 05, 2010
  23. Mar 02, 2010
  24. Feb 24, 2010
  25. Feb 23, 2010
  26. Feb 18, 2010
  27. Feb 02, 2010
  28. Nov 06, 2009
  29. Oct 08, 2009
  30. Oct 06, 2009
Loading