Running tests using Synopse mORMot framework 1.18.1810, compiled with Delphi 7, against SQLite 3.8.11.1, at 2015-08-19 18:42:11.
Insertion speed
Direct | Batch | Trans | Batch Trans | |
SQLite3 (file full) | 170 | 11746 | 99954 | 167740 |
SQLite3 (file off) | 271 | 18947 | 104666 | 195756 |
SQLite3 (file off exc) | 14704 | 189350 | 116759 | 240384 |
SQLite3 (mem) | 97117 | 270665 | 119146 | 271149 |
TObjectList (static) | 295578 | 452447 | 275999 | 446747 |
TObjectList (virtual) | 292705 | 441072 | 287273 | 423657 |
SQLite3 (ext full) | 184 | 6012 | 110700 | 165909 |
SQLite3 (ext off) | 304 | 5459 | 104602 | 181061 |
SQLite3 (ext off exc) | 22085 | 171927 | 135402 | 217164 |
SQLite3 (ext mem) | 119442 | 238174 | 137820 | 244690 |
WinHTTP SQLite3 (off exc) | 4303 | 65911 | 5718 | 76713 |
Socket SQLite3 (off exc) | 8621 | 92016 | 14884 | 114212 |
Read speed
By one | All Virtual | All Direct | |
SQLite3 (file full) | 143315 | 568634 | 608124 |
SQLite3 (file off) | 143196 | 592487 | 588858 |
SQLite3 (file off exc) | 143131 | 581801 | 587199 |
SQLite3 (mem) | 139621 | 608716 | 605400 |
TObjectList (static) | 276793 | 943218 | 946790 |
TObjectList (virtual) | 283816 | 433500 | 976944 |
SQLite3 (ext full) | 155216 | 260769 | 580181 |
SQLite3 (ext off) | 160426 | 260933 | 556978 |
SQLite3 (ext off exc) | 159989 | 254491 | 541770 |
SQLite3 (ext mem) | 157391 | 258692 | 584521 |
WinHTTP SQLite3 (off exc) | 5716 | 267079 | 470499 |
Socket SQLite3 (off exc) | 15147 | 265985 | 470411 |