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

[Gilles Caulier]

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 <zilexa at gmx.com> 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.