Hi! As KDEPIM 24.12 comes to unstable, I thought I'd write something up about this:
As I told before about KDEPIM 24.08 in experimental already: Using SQLite3 as database engine I faced a great deal of improved performance. The improvement has been impressive. And that compared to the already probably faster than MariaDB PostgreSQL engine I was using. I have been migrating the hard way. But there is a migrator available meanwhile: https://kontact.kde.org/blog/2024/2024-03-01-kde-pim-january-february-2024/ As far as I know this migrator is stable. However… I did not use it. As SQLite3 is the new recommended engine, it might be good to migrate at some point in time. But right now I can mostly only tell about my own experience… so if someone feels adventurous, give it a try and please report back. You help to get a clearer picture on how well it works in general. If you rather like to keep your current engine… sure I fully sympathize. Never change (and possibly break) a running system :) I am at least happy not having to upgrade PostgreSQL clusters again. SQLite3 should be pretty maintenance free. Digikam is using it. Firefox is using it for a ton of things and so on… In case you give it a try: *Make a backup first*! Ideally of your complete home directory while Akonadi is not running. And probably also with the import/export tool I mentioned before: KDE PIM data exporter https://lists.debian.org/debian-kde/2024/12/msg00065.html -- Martin - please no carbon copy to me
