"Muayyad AlSadi" <alsadi(a)gmail.com> writes:
> Why not use sqlite?
We tried. Really. It can't handle the concurrent access very
well, in
the best case this means very slow operations, but we've also seen
deadlocks and failing transactions. Once that's fixed in sqlite,
adjusting Akonadi to use it again instead of MySQL is no problem.
[ raised eyebrow... ] mysql's reputation for concurrent performance
is not exactly stellar either. I grant that table-wide locks are better
than database-wide locks, but unless you have a lot of independently
accessed tables in your DB design, it won't help much.
regards, tom lane