This is a multi-part message in MIME format.
--nextPart2954640.FA0FI3ke8A
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"
That sqlite3 metric is interesting indeed.
However even after the few upgrades to kdepim and korganizer since I opened this bug,
hoping they would fix this critical problem, the problem is still present: korganizer 4:24.12.2-1
kdepim 4:24.12.2+5.158
kdepimruntime 4:24.12.2-1
akonadiserver 4:24.12.2-1
As a sidenote I upgraded my computer to a Ryzen 9 X3D, and I can noticeably see that
when moving tasks or events around, it takes a few seconds less.
Everything seems to point to the fact that this slow response time is CPU-bound.
Not sure if this is related, but that bad Korganizer upgrade also broke at least 2 things:
- When using tags with accents in it, Korganizer mangle it so that for instance "é" appears
as "é", creating new faulty tags in the tags list.
- Sometimes when you edit a calendar task or event, the tags are just plain removed (even
if they do not contains any accent), which updates the events on Nextcloud, which are
replicated without any tags on the correct Korganizer clients (from Debian stable).
This is especially annoying on past meetings with other people where if you want to 'fix'
the missing tag, you need to edit the event..which will send the 'update' to every
attendees. Not possible in a work environement.
To sum up, before having 10k+ event was not a problem, now it is. Where do we go from
here?
Regards,
Alexandre Bonneau
Le mardi 14 janvier 2025, 10:17:12 heure de Tahiti Soren Stoutner a écrit :
On Monday, January 13, 2025 7:09:06 PM MST Alexandre Bonneau wrote:
Which database type are you using ?
» dlg akonadi
rc akonadi-backend-mysql 4:22.12.2-1
ii akonadi-backend-sqlite 4:24.12.0-2
I’m a little puzzled that you have 22.x for mysql and 24.x for sqlite. Testing currently has 24.x for both of them.
Although this doesn’t directly address your particular bug, which appears to
maybe be something that happens with large amounts of calendar entries, you might be interested in the discussion about how much faster sqlite runs compared to postgresql (and possibly mariadb).
https://lists.debian.org/debian-kde/2024/12/msg00079.html
--nextPart2954640.FA0FI3ke8A
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="utf-8"
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">That sqlite3 metric is interesting indeed.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">However even after the few upgrades to kdepim and korganizer since I opened this bug, hoping they would fix this critical problem, the problem is still present:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">korganizer 4:24.12.2-1</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">kdepim 4:24.12.2+5.158</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">kdepimruntime 4:24.12.2-1</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">akonadiserver 4:24.12.2-1</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">As a sidenote I upgraded my computer to a Ryzen 9 X3D, and I can noticeably see that when moving tasks or events around, it takes a few seconds less.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Everything seems to point to the fact that this slow response time is CPU-bound.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Not sure if this is related, but that bad Korganizer upgrade also broke at least 2 things:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">- When using tags with accents in it, Korganizer mangle it so that for instance "é" appears as "é", creating new faulty tags in the tags list.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">- Sometimes when you edit a calendar task or event, the tags are just plain removed (even if they do not contains any accent), which updates the events on Nextcloud, which are
replicated without any tags on the correct Korganizer clients (from Debian stable).</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">This is especially annoying on past meetings with other people where if you want to 'fix' the missing tag, you need to edit the event..which will send the 'update' to every
attendees. Not possible in a work environement.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">To sum up, before having 10k+ event was not a problem, now it is. Where do we go from here?</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Regards,</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Alexandre Bonneau</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Le mardi 14 janvier 2025, 10:17:12 heure de Tahiti Soren Stoutner a écrit :</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> On Monday, January 13, 2025 7:09:06 PM MST Alexandre Bonneau wrote:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > > Which database type are you using ?</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > » dlg akonadi</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > rc akonadi-backend-mysql 4:22.12.2-1</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > > ii akonadi-backend-sqlite 4:24.12.0-2</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> I’m a little puzzled that you have 22.x for mysql and 24.x for sqlite.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Testing currently has 24.x for both of them.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Although this doesn’t directly address your particular bug, which appears to</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> maybe be something that happens with large amounts of calendar entries, you</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> might be interested in the discussion about how much faster sqlite runs</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> compared to postgresql (and possibly mariadb).</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">>
https://lists.debian.org/debian-kde/2024/12/msg00079.html</p>
<br /><br /></body>
</html>
--nextPart2954640.FA0FI3ke8A--
-----BEGIN PGP SIGNATURE-----
iF0EABEKAB0WIQRbWzskGLftNYMKah8bd6g6OLvBPgUCZ+IUYQAKCRAbd6g6OLvB Pvl2AJ9wmWZvlk3wp8HBEsHfESqI+PK7QwCgv+mZLpcdiNvT3BxdCldBrsGyp98=
=lyxQ
-----END PGP SIGNATURE-----
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)