Running tests using Synopse mORMot framework 1.18.1810, compiled with Delphi XE6, against SQLite 3.8.11.1, at 2015-08-19 18:45:47.
Insertion speed
Direct | Batch | Trans | Batch Trans | |
SQLite3 (file full) | 172 | 12126 | 82097 | 152142 |
SQLite3 (file off) | 268 | 18898 | 85629 | 164891 |
SQLite3 (file off exc) | 14769 | 172538 | 94373 | 208681 |
SQLite3 (mem) | 80388 | 236127 | 92553 | 226603 |
TObjectList (static) | 205668 | 404891 | 206799 | 397677 |
TObjectList (virtual) | 205668 | 388470 | 203376 | 393050 |
SQLite3 (ext full) | 223 | 6038 | 90831 | 151989 |
SQLite3 (ext off) | 298 | 8225 | 96564 | 52856 |
SQLite3 (ext off exc) | 22082 | 157242 | 105744 | 197098 |
SQLite3 (ext mem) | 96039 | 214979 | 107190 | 220662 |
WinHTTP SQLite3 (off exc) | 4101 | 55500 | 5450 | 59709 |
Socket SQLite3 (off exc) | 8198 | 73659 | 14908 | 91876 |
Read speed
By one | All Virtual | All Direct | |
SQLite3 (file full) | 120429 | 582954 | 608865 |
SQLite3 (file off) | 121071 | 606575 | 620270 |
SQLite3 (file off exc) | 120872 | 608346 | 617894 |
SQLite3 (mem) | 121648 | 615308 | 622665 |
TObjectList (static) | 204632 | 940379 | 959324 |
TObjectList (virtual) | 204985 | 488185 | 936154 |
SQLite3 (ext full) | 131161 | 303342 | 615081 |
SQLite3 (ext off) | 123322 | 297194 | 590946 |
SQLite3 (ext off exc) | 131364 | 295124 | 589136 |
SQLite3 (ext mem) | 131682 | 297601 | 597514 |
WinHTTP SQLite3 (off exc) | 5504 | 252130 | 464166 |
Socket SQLite3 (off exc) | 14942 | 259848 | 476417 |