I'm trying to pick a RDBMS for usage as a backend for KDE's Akonadi PIM framework.
Problem is that the storage (/home partition) resides on a pretty slow SD card with reiser4 filesystem on it. The filesystem is based on COW and transactional model itself, so its
fsync() performance is very low - while InnoDB uses it for its own transaction system. Hence the whole system is practically unusable.
What can be done to improve this? Possible backends for Akonadi are: MySQL (with InnoDB and MyISAM backends), PostgreSQL and SQLite. Actually, no scalability is needed as there is the only client.