FPC 3.2 Win64

gistfile1.txt

Running tests using Synopse mORMot framework 2.0.1, compiled with Free Pascal 3.2 64 bit, against SQLite 3.36.0, on Windows 7 64bit SP1 (6.1.7601), at 2021-10-01 22:55:55.


Insertion speed (rows/second)
                              Direct      Batch       Trans       Batch Trans
Sqlite file full              420         26493       115199      316225
Sqlite file off               2456        130843      122234      390426
Sqlite file off exc           48965       362963      123272      398295
Sqlite file off exc aes       28456       314801      121288      391527
Sqlite in memory              100030      413445      124868      410458
In memory static              235122      571984      244331      569411
In memory virtual             234203      571755      241266      564716
External sqlite file full     440         28752       119634      228055
External sqlite file off      2701        132708      126707      355265
External sqlite file off exc  60236       347174      125134      365056
External sqlite in memory     100472      394383      117381      396778
Remote sqlite win HTTP        3779        118360      3919        97964
Remote sqlite socket          6777        149729      6877        154102

Read speed (rows/second)
                              By one      All Virtual All Direct
Sqlite file full              40950       960430      970873
Sqlite file off               40863       966837      962556
Sqlite file off exc           214984      975704      968804
Sqlite file off exc aes       195163      976657      967305
Sqlite in memory              223109      994431      967211
In memory static              312314      1819505     1720578
In memory virtual             308213      714694      718081
External sqlite file full     155057      516635      926354
External sqlite file off      179833      510803      926526
External sqlite file off exc  180596      494193      918020
External sqlite in memory     216558      941265      944911
Remote sqlite win HTTP        3793        393654      714183
Remote sqlite socket          7764        403697      731261