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 4636A13877A for ; Tue, 12 Aug 2014 06:43:49 +0000 (UTC) Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 2C82DE0B6E; Tue, 12 Aug 2014 06:43:43 +0000 (UTC) Received: from mail-wi0-f173.google.com (mail-wi0-f173.google.com [209.85.212.173]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (No client certificate requested) by pigeon.gentoo.org (Postfix) with ESMTPS id A15F3E0B2A for ; Tue, 12 Aug 2014 06:43:41 +0000 (UTC) Received: by mail-wi0-f173.google.com with SMTP id f8so5331372wiw.0 for ; Mon, 11 Aug 2014 23:43:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; bh=hJM+rgVC+Oyi/wvPDgNr7D7KK+bZmVWZYRdMk0KFxmI=; b=Q2BS3sJ6hfL1IP1kyqn/b1wZnm4GpSWBzZLCtD2F9Kzfqy3kajxhTKWWuWCoGuD6+F blsUQFG/P/lECX6tgC8z96/KD44hwLsGwlIvwSYmHK40AXItjJmecmpdU4r9nc/iycH/ HQtGYy9UnwSyTrRs7Ppg3mYkfv/78JsGRCplRkwutqhsBCmszct+scRexsk+QFlz/zzu sjDKW0tTmL+BHunk5fzYGRqIzEeeZZoD6QcJKi3c7SgEA3ze4mEzLqGUTuvPDtNdpX+y b8ASj6E914L7qNkrHgvoQ+nbdTi4+W0YKTssuNeVhpR2u1OIKTTQsFmZER+gcj3YTp1d wjxQ== X-Received: by 10.180.98.196 with SMTP id ek4mr30892524wib.13.1407825820220; Mon, 11 Aug 2014 23:43:40 -0700 (PDT) Received: from [172.20.0.40] (105-237-190-183.access.mtnbusiness.co.za. [105.237.190.183]) by mx.google.com with ESMTPSA id z5sm6948695wje.49.2014.08.11.23.43.39 for (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 11 Aug 2014 23:43:39 -0700 (PDT) Message-ID: <53E9B766.7040607@gmail.com> Date: Tue, 12 Aug 2014 08:42:46 +0200 From: Alan McKinnon User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.0 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 To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] akonadi ... don't you just love it? References: <201408092100.58965.michaelkintzios@gmail.com> <53E904EC.4080405@googlemail.com> <1745146.UBF9IXZqKh@aspire> <1573911.bTZgDrGOdb@andromeda> In-Reply-To: <1573911.bTZgDrGOdb@andromeda> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Archives-Salt: 296cb5ee-1bc9-4a8f-abed-db4ffe84f9ee X-Archives-Hash: 5821d20339449183a60ae75465cf5b7c 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. >>> >>> But, no, they had to break that. >>> >>> 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. >>> >>> Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup* >> >> 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. :-( > > 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. > > 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. > > I really don't see the point of forcing mysql as a backend. Sqlite would have > been a better choice. 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. 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. Amarok incidentally has almost exactly the same issues and the same solution was adopted -- Alan McKinnon alan.mckinnon@gmail.com