On 17/02/2011 16:41, Martin wrote:

> all back then. But in the meantime I have heard from other people
> that Firebird is also a pretty speedy db; is this true? The best

<chomp!>

> don't need. InnoDB speed is acceptable, though. We also tried MariaDB

I have written an application that will work (via DAO/ODBC) with MS Jet,
Firebird, PostgreSQL and MySQL (InnoDB for safety). To compare the
databases I added a speed test, which is basically just a load of
transactions of the type with which the DB has to work. Jet was by far
and away the fastest, but it most certainly isn't a safe database. In
second place came Firebird. PostgreSQL took third place, and MySQL
(InnoDB) came in last. The test is unfair because it wasn't optimised
for any database, except perhaps Jet as the application was originally
written for Jet only. Also the transactions will be wildly different
from yours. So take the results I achieved with a huge pinch of salt,
but it does suggest that it would be worth your while looking at
Firebird - and applying a test based on your own requirements.

Regards,

Robert.

--
() Plain text email - safe, readable, inclusive.
/\ http://www.asciiribbon.org/