Re: [fossil-users] pragma journal_mode=wal

[Olivier Mascia]

> Le 3 janv. 2018 à 13:03, Olivier Mascia  a écrit :
> 
> Is the page size 8K, instead of SQLite current default of 4K which Fossil 
> preserves on a "fossil new" for instance, also a generally 
> preferred/recommended configuration for Fossil repositories, or an ad-hoc 
> setting for this specific repository?

Along the same line... I see "fossil new" uses the default SQLite page size of 
4K.
Though "fossil clone http://www.fossil-scm.org/ fossil.fossil" do reproduce 
locally the 8K page size from its source.

What other technical settings of a cloned repository are implicitly preserved 
to its clones?
(The journal_mode=WAL is not, and I understand why it is so).

-- 
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia


___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Re: [fossil-users] pragma journal_mode=wal

[Olivier Mascia]

> Le 3 janv. 2018 à 12:57, Richard Hipp  a écrit :
> 
> WAL-mode is preferred.

Thanks!

> If you visit https://www.fossil-scm.org/fossil/stat and look at the
> end of the "Database Stats:" line, you'll see that the canonical
> Fossil repo runs in WAL mode.

Is the page size 8K, instead of SQLite current default of 4K which Fossil 
preserves on a "fossil new" for instance, also a generally 
preferred/recommended configuration for Fossil repositories, or an ad-hoc 
setting for this specific repository?

-- 
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia


___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Re: [fossil-users] pragma journal_mode=wal

[Richard Hipp]

On 1/3/18, Olivier Mascia  wrote:
>
> Assuming a main repository only accessed through HTTP for clone, push, pull
> or through its web interface... Would you see a reason for not switching it
> to WAL mode?
>
> Should it be avoided for a well-known reason in that restricted
> configuration?

WAL-mode is preferred.

If you visit https://www.fossil-scm.org/fossil/stat and look at the
end of the "Database Stats:" line, you'll see that the canonical
Fossil repo runs in WAL mode.

-- 
D. Richard Hipp
d...@sqlite.org
___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

[fossil-users] pragma journal_mode=wal

[Olivier Mascia]

Dear,

Assuming a main repository only accessed through HTTP for clone, push, pull or 
through its web interface... Would you see a reason for not switching it to WAL 
mode?

Should it be avoided for a well-known reason in that restricted configuration?

-- 
Best Regards, Meilleures salutations, Met vriendelijke groeten,
Olivier Mascia


___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users