DB performance and consistency

[Gilles Caulier]

Le mer. 21 août 2024 à 15:08, Jérôme <jdemeulle.pub at gmail.com> a écrit :
>
> Does anyone have advises concerning the perf DB to use for the best perf ?
> I'm new user testing DK and I'm using internal MySQL (with MariaDB) with a first collection of images (about 170K photos) to begin (objective is 300K).
> I will switch to SQLite with WAL to check if perf are better, it takes more than 1 hour freezed after clicking on similar view (with MariaDB using all CPU inside DK).

Look here : https://docs.digikam.org/en/setup_application/database_settings.html#database-type-criteria

> With DK 8.4, is there is way/tools to check consistency of the DB ?

Look here : https://docs.digikam.org/en/maintenance_tools/maintenance_database.html

Best

Gilles Caulier