On Fri, Oct 14, 2011 at 2:08 AM, Bruno Friedmann
On 10/13/2011 05:11 PM, Andras Mantia wrote:
Bruno Friedmann wrote:
On 10/13/2011 03:38 PM, Andras Mantia wrote:
Hi,
I'd like to draw the attention to bug 718367, in case it is still the case of shipping Akonadi to be configured to SQLite by default, please reconsider the decision. This will provide sub-optimal performance and in certain cases buggy behavior (hangs) for Akonadi based applications, including KMail2.
Andras
Andras you know that the sqlite choice was also made because there's no upstream solution for the buggy mysql support on nfs home too :-)
[dream on] One unified full semantic database (that can be per user, per computer, per network) for the whole kde desktop. With a nice administrative stack to dig in it, backup, restore, migrate [/dream off]
Ok, I didn't know about the NFS problem (you refer to the unclear shutdown/broken suspend issue, right: https://bugs.kde.org/show_bug.cgi?id=275261 ? ). So you need to make a choice: - use sqlite and make it a problem for everybody - use mysql and those using NFS will have a problem
Right now I'd say even postgresql would be a better choice, but I have no idea how it works on NFS.
Unfortunately, the postgresql is not a solution. If you configure it by hand to use an external database server, akonadi doesn't care and launch it's own instance. (known bug which will be resolved in 4.8 from what was said to me)
I wouldn't really consider that a bug. It'd be nice to have the choice between "use an external postgresql server" and "launch our own postgresql instance".
The fact is what I wrote: sqlite is buggy. I run into the mistake of using sqlite once, when I removed my akonadi config and run the opensuse akonadi instead of my self compiled one. And that was patched and used sqlite. I didn't notice for a day or so, but my number of gray hairs went up and couldn't understand why do I get so frequent hangs in KMail and the Akonadi server.
Andras
I've never consider sqlite as database engine.
That's unfortunate - sqlite has an excellent SQL engine and is pretty reliable/durable. It's not intended to replace mysql or postgresql but for what it does, it does a very good job. -- Jon -- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org