PerfTests Win32 Delphi XE8

gistfile1.txt

Running tests using Synopse mORMot framework 2.0.1, compiled with Delphi XE8 32 bit, against SQLite 3.36.0, on Windows 7 64bit SP1 (6.1.7601), at 2021-10-01 22:51:36.


Insertion speed (rows/second)
                              Direct      Batch       Trans       Batch Trans
Sqlite file full              412         24035       84798       262743
Sqlite file off               2450        114575      91237       308499
Sqlite file off exc           39312       281301      85116       317561
Sqlite file off exc aes       24192       246153      91617       252353
Sqlite in memory              72935       313666      91880       321947
In memory static              188764      490075      192711      526565
In memory virtual             187385      507639      193858      508362
External sqlite file full     461         28449       103534      240865
External sqlite file off      2607        105253      108122      271835
External sqlite file off exc  53308       264767      108911      272094
External sqlite in memory     74661       292295      92115       313794
Remote sqlite win HTTP        3530        110160      3679        100014
Remote sqlite socket          5384        120762      5494        123360

Read speed (rows/second)
                              By one      All Virtual All Direct
Sqlite file full              30493       601359      597442
Sqlite file off               30877       601069      601322
Sqlite file off exc           107525      606501      601106
Sqlite file off exc aes       113484      570092      598694
Sqlite in memory              114695      607607      605326
In memory static              205672      1270325     1289158
In memory virtual             198787      394804      403014
External sqlite file full     120813      301786      603974
External sqlite file off      121558      301804      591121
External sqlite file off exc  122164      302151      605620
External sqlite in memory     114288      605216      609904
Remote sqlite win HTTP        3672        252966      453391
Remote sqlite socket          5647        266922      433087