Synopse mORMot framework 1.18.5894 Database Benchmark

gistfile1.txt

Running tests using Synopse mORMot framework 1.18.5894, compiled with Free Pascal 3.1.1 64 bit, against SQLite 3.31.0, on Ubuntu 18.04.4 LTS - Linux 5.3.0-42-generic, at 2020-03-24 20:41:32.


Insertion speed (rows/second)
                              Direct      Batch       Trans       Batch Trans
Sqlite file full              493         16855       39053       131919
Sqlite file off               7131        113695      41897       145142
Sqlite file off exc           14263       132897      42718       145751
Sqlite file off exc aes       11009       119731      43836       132890
Sqlite in memory              23748       139762      43884       145234
In memory static              94344       257360      100323      238174
In memory virtual             84898       230616      96650       249301
External sqlite file full     450         11724       28077       97572
External sqlite file off      8692        86879       39874       110499
External sqlite file off exc  22585       108915      42057       117816
External sqlite in memory     25818       103859      37929       107545
Remote sqlite socket          8381        62078       8360        56891
SynDBPostgres                 1464        80568       5529        90072
Zeos postgres                 1472        91026       5619        91257

Read speed (rows/second)
                              By one      All Virtual All Direct
Sqlite file full              20547       412133      411218
Sqlite file off               30911       316696      245254
Sqlite file off exc           45925       410677      399680
Sqlite file off exc aes       40435       245990      248546
Sqlite in memory              46064       418235      415454
In memory static              83909       723693      804505
In memory virtual             99866       314643      326115
External sqlite file full     56820       202560      396322
External sqlite file off      55713       198807      402155
External sqlite file off exc  58409       211246      385415
External sqlite in memory     61161       205939      407265
Remote sqlite socket          10436       196055      343878
SynDBPostgres                 5787        173635      343500
Zeos postgres                 4827        165469      325034