Stéphane,

Leyne, Sean schrieb am 19.12.2010 um 21:44 (-0500):

>
> > I have done a benchmark tool to compare Mysql / Firebird / SqlIte3

> It is COMPLETELY inappropriate to compare them.
>
> If you want SQLLite performance use it! If you want scalable/
> multi-user/simultaneous operations use Firebird […] you could get
> FANTASTIC performance from simple key/value databases but that doesn't
> mean that you would want to use it in place of Firebird.

How about setting up triggers to feed a log table from which to feed a
dedicated search system (sqlite or any other suitable engine), which
might then lag behind by some minutes but is optimized for searching?

If this is a foolish or problematic suggestion, I'd like to know.

> P.S. As for MySQL, depending on the storage engine used, it is also
> an inappropriate candidate for comparison with Firebird -- the basic
> ISAM storage doesn't support transactions.

I think you mean MyISAM, which also doesn't do transactions. ISAM
support has been discontinued in versions above 3.23.

http://dev.mysql.com/doc/refman/4.1/en/isam-storage-engine.html

--
Michael Ludwig