[Akonadi] [Bug 338571] Performance Regression: Folder synchronisation in Akonadi 16.08 (actually in any release, starting with KDE 4.14) very slow, compared to kMail from KDE 4.13.x

[Martin Steigerwald via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=338571

--- Comment #25 from Martin Steigerwald <Martin at Lichtvoll.de> ---
Okay, I seriously don´t get why its so different for you: One folder with about
10000 mails about one second with cold caches and one with more than 24000
mails about 2-3 seconds with cold caches. This time on Dovecot based IMAP.
Regular IMAP, not disconnected. You do have double the amount of mails than the
larger one of my folders, Gunther, but opening your sent folder takes about
30-40 times longer than on my system.

So there is hope to fix your issue, I think, once it is clear what is causing
the high load on your system. I wonder how to find whats different tough. Care
to share more details of your setup? Also… do you have any search folders that
target mails of your sent folder?

My IMAP account setup is very basic. I just pointed it to my Dovecot IMAP, and
then let it autodetect the encryption. Thats it. No customizations so far. So
what you could try would be: Use a *new* user, recreate IMAP account from
scratch. And try then. Also are there any errors Akonadi shows in
~/.xsession-errors or Akonadi error log. Are there any errors in MySQL log?

Okay, just reading your mid air collision comment as well: So you have local
IMAP, that should be even faster. I also tried clicking folder and then
clicking mails. Its just instant with warm caches, i.e. folder already opened
before. Okay, and even with cold caches, after the initial delay of 1-3 seconds
and maybe an added second its instant. I click mail and its done. IMAP resource
doesn´t synchronize the folder on my setup when clicking mails in a folder that
it synchronized initially after starting it. What I know is that it does when
deleting mail and this can cause quite some slow downs, but not when reading
mails. So are you doing any other changes to the mail other than KMail setting
read flag on them?

I can reproduce huge delays when entering inbox for example and then hit delete
10-20 times. But but its not that MySQL heavy. It is just that Akonadi IMAP for
some reason resynchronizes folder content after deleting a mail. So I think
that is a different issue.

Okay, will post about query logs in next comment.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.