Synopse mORMot framework 1.18.5895 ORM Benchmark

gistfile1.txt

Running tests using Synopse mORMot framework 1.18.5895, 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 21:02:31.


Insertion speed (rows/second)
                              Direct      Batch       Trans       Batch Trans
Sqlite file full              507         18308       50041       132703
Sqlite file off               7796        112989      55336       146322
Sqlite file off exc           20705       134321      55041       143299
Sqlite file off exc aes       13779       120186      55219       134134
Sqlite in memory              45243       147684      55710       145408
In memory static              90107       237665      122531      264900
In memory virtual             115663      255597      119855      260538
External sqlite file full     448         9981        47545       134564
External sqlite file off      9674        103150      60436       146985
External sqlite file off exc  28599       134978      60428       149494
External sqlite in memory     54080       149907      61707       151952
Remote sqlite socket          10204       71554       10700       76261
SynDBPostgres                 1386        91849       6379        95307
Zeos postgres                 1524        84598       6367        93445

Read speed (rows/second)
                              By one      All Virtual All Direct
Sqlite file full              39185       418760      418550
Sqlite file off               38651       426657      421443
Sqlite file off exc           61696       421300      426949
Sqlite file off exc aes       61829       422654      424196
Sqlite in memory              61333       426003      433500
In memory static              130103      788270      839066
In memory virtual             127632      324991      334291
External sqlite file full     72456       215964      396070
External sqlite file off      72026       218732      408697
External sqlite file off exc  70117       217183      419216
External sqlite in memory     72867       220916      404989
Remote sqlite socket          11087       196086      342301
SynDBPostgres                 6480        182076      344305
Zeos postgres                 5402        162924      326498