Re: KDEPIM with SQLite3

From	Martin Steigerwald <martin@lichtvoll.de>
Newsgroups	linux.debian.maint.kde
Subject	Re: KDEPIM with SQLite3
Date	2026-02-28 22:40 +0100
Message-ID	<MtAcx-42n3-21@gated-at.bofh.it> (permalink)
References	<MtAcx-42n3-23@gated-at.bofh.it> <JV6lj-yjy-7@gated-at.bofh.it> <MtoO5-3URx-3@gated-at.bofh.it> <MtyNs-41yT-7@gated-at.bofh.it>
Organization	linux.* mail to news gateway

Show all headers | View raw

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.

I did have those pauses during POP3 retrieval also with MariaDB and 
PostgreSQL. In fact I have them since a very long time. And I think the 
issue is even known upstream:

Look at how to improve pop3 support

https://invent.kde.org/pim/pim-technical-roadmap/-/issues/36

Also I do not see any relevant KDEPIM / Akonadi process activity. It is 
just sitting there, idle. Or waiting on… whatever.

Best,
-- 
Martin

Back to linux.debian.maint.kde | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: KDEPIM with SQLite3 yaros <yaros42@posteo.net> - 2026-02-28 09:10 +0100
  Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2026-02-28 10:30 +0100
    Re: KDEPIM with SQLite3 yaros <yaros42@posteo.net> - 2026-02-28 10:30 +0100
    Re: KDEPIM with SQLite3 Soren Stoutner <soren@debian.org> - 2026-02-28 21:10 +0100
      Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2026-02-28 22:40 +0100
        Re: KDEPIM with SQLite3 Soren Stoutner <soren@debian.org> - 2026-03-08 00:30 +0100

csiph-web