On Thu, Feb 21, 2013 at 9:25 AM, Richard Hipp <[email protected]> wrote: > > > On Thu, Feb 21, 2013 at 11:21 AM, Matt Welland <[email protected]> wrote: >> >> Database Stats: 209478 pages, 1024 bytes/page, 113 free pages, UTF-8, >> delete mode > > > That "delete mode" notation on the end denotes the problem. You need to > change your repository on the server to WAL mode. Do this as follows: > > sqlite3 $repository 'pragma journal_mode=wal' > > Or > > fossil rebuild $repository --pagesize 8192 --wal > > The second method will take (much) longer, but it also changes the page size > from 1024 bytes to 8192 bytes, which won't make a huge difference but will > help some.
We can't switch to WAL mode currently as these repos are accessed from multiple machines via NFS. Now that ssh is working for us we can convert over to using ssh to a central server and switch to WAL mode at the same time. Is there any downside to using ssh? How dramatic is the performance improvement with WAL mode? Thanks. > > > -- > D. Richard Hipp > [email protected] > > _______________________________________________ > fossil-users mailing list > [email protected] > http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users > _______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
