Le 15 mai 2014 05:14, "Richard Hipp" <d...@sqlite.org> a écrit : > > > > > On Thu, May 15, 2014 at 12:51 AM, Andy Bradford <amb-fos...@bradfords.org> wrote: >> >> Hello, >> >> I recently noticed that if I hit /stat on my own repositories it shows >> ``delete mode'' in the Database Stats, but on www.fossil-scm.org it >> shows ``wal mode.'' I assume this is to leverage some of the benefits >> listed here: >> >> https://www.sqlite.org/draft/wal.html >> >> I suppose it can be enabled just using the sqlite interface? Can this >> actually improve the number of locking contentions that might exist for >> a given fossil? > > > Right. WAL mode allows other processes to continue reading while one process writes, thus avoiding many locks. To enable WAL mode, just run: > > echo 'PRAGMA journal_mode=WAL;' | fossil sql
There's also 'fossil rebuild --wall', but it's good to know using raw SQL which is faster if you have a very big repo (I imagine doing the rebuild on the netbsd pkgsrc repo). -- Martin G.
_______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
