On Saturday, February 28, 2026 2:37:22 PM Mountain Standard Time Martin Steigerwald wrote: > Greetings Soren, greetings. > > Soren Stoutner - 28.02.26, 21:06:53 CET: > > On Saturday, February 28, 2026 2:20:29 AM Mountain Standard Time Martin > > > > Steigerwald wrote: > > > Akonadi SQLite3 continues to be faster and more robust than with > > > MariaDB or PostgreSQL for me. But unfortunately it is still not > > > perfect. At least with POP3 mail retrieval there can still be quite > > > odd delays. With a light IMAP account I have in another setup it > > > works nicely. > > > > My personal experience is that with a large IMAP system (125 MiB > > akonadi.db file) it freezes a lot with SQLite3, particularly when > > deleting large amounts of emails. Sometimes those freezes can last > > minutes, during which, if further deletion of emails is attempted, they > > GUI continues to display them. In some instances, the deletions are > > queued and later processed. In other instances the deletions are never > > processed. I assume it is because the database is being compacted and > > it takes a while to process. > > You did not have that with MariaDB or PostgreSQL? Do you see any Akonadi > process activity? I think SQLite3 should be running within Akonadi's main > process: /usr/bin/akonadiserver.
Yes, but the pause with MariaDB is more on the order of a second or less. > Also I do not see any relevant KDEPIM / Akonadi process activity. It is > just sitting there, idle. Or waiting on… whatever. When this happened to me with SQLite3, there was not significant CPU or disk activity. I didn’t spend much time looking into it, but my guess is there is some inefficient algorithm that is neither CPU nor disk bound that causes the deal. -- Soren Stoutner [email protected]
signature.asc
Description: This is a digitally signed message part.
