PerfTests Win64 XE8

gistfile1.txt

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


Insertion speed (rows/second)
                              Direct      Batch       Trans       Batch Trans
Sqlite file full              458         28616       123155      328558
Sqlite file off               2507        127749      127621      364245
Sqlite file off exc           50578       342032      127787      371982
Sqlite file off exc aes       50289       341227      118012      223553
Sqlite in memory              96394       371871      129394      380126
In memory static              257911      569573      276441      562872
In memory virtual             237552      527120      274649      533504
External sqlite file full     453         22361       126794      275080
External sqlite file off      2674        131442      139815      305754
External sqlite file off exc  63970       319795      140759      341821
External sqlite in memory     96380       377886      129822      383420
Remote sqlite win HTTP        3876        117284      3921        116987
Remote sqlite socket          5499        135087      5514        132826

Read speed (rows/second)
                              By one      All Virtual All Direct
Sqlite file full              39312       921998      927643
Sqlite file off               38825       924299      926612
Sqlite file off exc           188529      898472      895977
Sqlite file off exc aes       201328      913993      908100
Sqlite in memory              200004      936680      934230
In memory static              303526      1665278     1661957
In memory virtual             301522      667824      655222
External sqlite file full     171276      520833      927729
External sqlite file off      170940      522193      926183
External sqlite file off exc  174219      514085      933184
External sqlite in memory     204607      932487      922509
Remote sqlite win HTTP        3956        405663      692664
Remote sqlite socket          5612        410863      692233