Synopse Open Source

This preliminary results came from the same hardware than previously used on this blog.
In short: notebook with a SSD and Core i7 mobile.

Note that these tests are not about the relative speed of each database engine, but reflect the current status of the integration of several DB libraries within the mORMot database layer.
Purpose here is not to say that one library is better or faster than another, but publish a snapshot of mORMot persistence layer abilities.
In this timing, we do not benchmark only the "pure" SQL-DB layer access (SynDB* units), but the whole Client-Server ORM of our framework: process below includes read and write RTTI access of a TSQLRecord, JSON marshalling, CRUD/REST routing, virtual cross-database layer, SQL on-the-fly translation. We just bypass the communication layer, since TSQLRestClient and TSQLRestServer are run in-process, in the same thread - as a TSQLRestServerDB instance. So you have here some raw performance testimony of our framework's ORM and RESTful core.

Jet/MSAccess database engine is accessed via OleDB.
NexusDB is the free embedded edition, which is a perfect match for a Client-Server ORM framework like mORMot.
Oracle server is a remote 11g instance, accessed with a "slow" 100 MB network.
SQLite3 is our static embedded engine, either as internal or external database, or the latest 3.7.15.2 official sqlite3.dll library, for ZEOS and UniDAC.
TObjectList is our in-memory optimized engine, with hashed indexes, and able to persist its data as JSON file or an optimized and compressed binary content.

Insertion speed

We use the sample provided within the source code tree, i.e. "15 - External DB performance".

NexusDB has a pretty good insertion speed, but no "BATCH" mode, nor prepared statement re-use. But not bad for such a small unit.
ZEOS also lacks of some optimizations like prepared statement cache, but does work well for an Open Source free solution.

Read speed

Read speed is comparable to insertion speed.
Depending on the design of each library, results are similar.

BDE performance is not so good, indeed. When working with Oracle, it is pretty slow, especially when retrieving data.
But it (still) works!

Both Jet/MSAccess and NexusDB are pretty good, as embedded engines, for reading.
Of course, our direct SQlite3 or in-memory TObjectList engines are incredibly fast. Just as usual.

We are working on direct integration of Firebird (either directly via an unfinished SynDBFirebird.pas unit, or via ZEOS / Unidac / any TDataset based component), but we are still fighting with some configuration issues.
Any help is welcome. Don't be shy!

The SAD pdf (in its 1.18 revision) has been updated to include information about external database connection via those libraries.

Feedback is welcome on our forum.