From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from lists.gentoo.org (pigeon.gentoo.org [208.92.234.80]) by finch.gentoo.org (Postfix) with ESMTP id 225F713877A for ; Tue, 12 Aug 2014 09:10:36 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 78EE4E0C90; Tue, 12 Aug 2014 09:10:28 +0000 (UTC) Received: from mail-wg0-f47.google.com (mail-wg0-f47.google.com [74.125.82.47]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id 260EFE0BC5 for ; Tue, 12 Aug 2014 09:10:26 +0000 (UTC) Received: by mail-wg0-f47.google.com with SMTP id b13so9421967wgh.6 for ; Tue, 12 Aug 2014 02:10:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=from:reply-to:to:subject:date:user-agent:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; bh=WDZkb3MmPs/aSU64Ba/UVSBzpVcueeWvSo/RuGAQJoU=; b=kEZmUaCvuAX7/HUOVOHXUrRJ1AlzfBziXWkcHYqG7te0/1FVDDMdDXPZ/Tlu5JadVS Wuhl8255A4zFnUdqu6Nrtz/plnIbcCPgivJ8qRFuPdXPs0ZGbtxS3SBfLWEUVZUv7ya+ fJMaxW8dVmcaI5bRsNyqgENacKkXw6khydpUB9Hke+klwZpeZlgePwNwDliWyBLMYJ5z BkhPmyPjfkZU70FRCVQzGQTr+W6vkZQezyqC57VoZ1wT6PbiPnt4zvD158ERaPvv1BNb 5KRyxE7VkI49mhzbOM1HamgF6kCy+XlKPBmtRFADd/Nq0cf9RRmAI9dfNd0yDhQPNLWX ouIQ== X-Received: by 10.180.108.13 with SMTP id hg13mr32237598wib.28.1407834625513; Tue, 12 Aug 2014 02:10:25 -0700 (PDT) Received: from dell_xps.localnet (230.3.169.217.in-addr.arpa. [217.169.3.230]) by mx.google.com with ESMTPSA id kt3sm7812992wjb.37.2014.08.12.02.10.23 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 12 Aug 2014 02:10:24 -0700 (PDT) From: Mick To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] akonadi ... don't you just love it? Date: Tue, 12 Aug 2014 10:10:02 +0100 User-Agent: KMail/1.13.7 (Linux/3.14.14-gentoo; KDE/4.12.5; x86_64; ; ) References: <201408092100.58965.michaelkintzios@gmail.com> <1573911.bTZgDrGOdb@andromeda> <53E9B766.7040607@gmail.com> In-Reply-To: <53E9B766.7040607@gmail.com> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1579276.DIkGGon3qL"; protocol="application/pgp-signature"; micalg=pgp-sha256 Content-Transfer-Encoding: 7bit Message-Id: <201408121010.14344.michaelkintzios@gmail.com> X-Archives-Salt: 7764247d-ba7c-4ee4-b788-7fccb8c6b431 X-Archives-Hash: 1ba5c751f61afc0a64565ddc9f1b949c --nextPart1579276.DIkGGon3qL Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On Tuesday 12 Aug 2014 07:42:46 Alan McKinnon wrote: > On 12/08/2014 07:36, J. Roeleveld wrote: > > On Monday, August 11, 2014 10:45:07 PM Mick wrote: > >> On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote: > >>> isn't it great? back in the days when kmail stored emails in files, > >>> everything worked great and even folders with 100k mails were not a > >>> problem. > >>>=20 > >>> But, no, they had to break that. > >>>=20 > >>> I lost ca 500k emails thanks to akonadi-crap and errors like that. I > >>> really loved kmail and thunderbird is garbage compared - but akonadi > >>> took away that choice. > >>>=20 > >>> Thank you, kdepim-devs for making the dumbest decision ever! *thumbsu= p* > >>=20 > >> I share your feelings although I haven't lost messages in my current > >> attempt to road test kmail2. I am dreading the moment when kmail1 will > >> stop working due to bitrot and I'll have to make a choice. :-( > >=20 > > With a modern machine and the latest versions, it's not too bad and > > responds quicker then kmail-1 did. With the old version, I often had > > kmail become unresponsive when synchronizing the email. > >=20 > > I didn't loose any emails, but that is more likely related to the emails > > being stored on an imap server, rather then being lucky. > >=20 > > I really don't see the point of forcing mysql as a backend. Sqlite would > > have been a better choice. >=20 > Way back when in the dark days of KDE-4.4 or thereabouts, the KDE devs > did do extensive tests with mysql vs sqlite and found sqlite lacking in > horsepower. Remember that it must store the metadata for all your mails > and some of us have lots of mail. IIRC there was also serious contention > issues with multiple threads. >=20 > sqlite is an amazing little product, but it does have it's limits. It > performs really well as an embedded datastore to replace flat file > storage with an SQL interface, and my gut-feel evaluation is that it > runs out of steam at similar orders of magnitude of data. >=20 > Amarok incidentally has almost exactly the same issues and the same > solution was adopted Only to add that it's more than just mail. It is the meta/data of the whol= e=20 caboodle of the PIM suite of applications. I recall the devs explicitly stating early enough in the KDE4 development t= hat=20 sqlite is not man enough for the job and advising everyone to move over to= =20 mysql. Someone was looking at postgresql as an alternative to mysql, but I'm not s= ure=20 that this would bring any benefit. =2D-=20 Regards, Mick --nextPart1579276.DIkGGon3qL Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAABCAAGBQJT6dn2AAoJELAdA+zwE4YeztAIAJrmqyW9bm6qJBQcV7LH8elk 2zpIIAUsI7f8AURSiHQph6+PfgogVDylJNL3uoSBUyBpW341crmTJsW/7dd2XfDO QhB+MH3XDdXM3bT91iAm8uLapbwXXz6h64fpXKW8MVg1CF7EnnlH3cINXTLZRHqq Gfa5NPgLA32XAE0uLQiIcXgumll62RX7se/mZpqxOPRW7oeHlbbUUYZKDGhSxWrX WiDm46pU4xTmkqzt7KOaAHctTPpkoNiMAAKzlXOxBGKZxopxwuh8hkm8za6oTmQg 6Q6PkmB8+zSo0qMP/zRxOYSMj6TXNaBty14FfImzJ2R4S2o4tjk2IyQDI71mTF4= =RWXh -----END PGP SIGNATURE----- --nextPart1579276.DIkGGon3qL--