[digiKam-users] Does digikam use WAL mode for its SQLite databases? (btrfs filesystem)

[ZileXa www]

Hi all, for the btrfs filesystem with its CoW behaviour, WAL mode is recommended for SQLite databases.

Modern software use this mode by default. Does Digikam (v7.2) doe this by default for all its SQLite databases?

Here are some results of using SQLite on btrfs filesystem with WAL enabled.

It also reduces the wear on your SSD:https://wiki.tnonline.net/w/Blog/SQLite_Performance_on_Btrfs

 

Thanks in advance for any responses or confirmations.

[Gilles Caulier-4]

Hi,

No. digiKam default journal mode (DELETE)

https://sqlite.org/pragma.html#pragma_journal_mode

If you want to see WAL mode used in the future please open a remember
wish in bugzilla.

Thanks in advance

Gilles Caulier

Le sam. 27 mars 2021 à 23:21, ZileXa www <[hidden email]> a écrit :
>
> Hi all, for the btrfs filesystem with its CoW behaviour, WAL mode is recommended for SQLite databases.
> Modern software use this mode by default. Does Digikam (v7.2) doe this by default for all its SQLite databases?
> Here are some results of using SQLite on btrfs filesystem with WAL enabled.
> It also reduces the wear on your SSD:https://wiki.tnonline.net/w/Blog/SQLite_Performance_on_Btrfs
>
> Thanks in advance for any responses or confirmations.