Running tests using Synopse mORMot framework 1.18.1648, compiled with Delphi XE8, against SQLite 3.8.10.2, at 2015-08-20 09:37:42.
Insertion speed
Direct | Batch | Trans | Batch Trans | |
SQLite3 (file full) | 163 | 10586 | 70493 | 129412 |
SQLite3 (file off) | 223 | 16230 | 76154 | 143711 |
SQLite3 (file off exc) | 1902 | 56607 | 84416 | 157564 |
SQLite3 (mem) | 77350 | 226029 | 88318 | 231470 |
TObjectList (static) | 202543 | 471297 | 210375 | 470987 |
TObjectList (virtual) | 198664 | 460914 | 190774 | 413941 |
SQLite3 (ext full) | 215 | 5884 | 83767 | 140390 |
SQLite3 (ext off) | 284 | 7518 | 83519 | 143274 |
SQLite3 (ext off exc) | 3120 | 45619 | 94350 | 168191 |
SQLite3 (ext mem) | 89705 | 212296 | 103267 | 213793 |
WinHTTP SQLite3 (off exc) | 1776 | 28305 | 4146 | 60084 |
Socket SQLite3 (off exc) | 2241 | 31042 | 8296 | 79602 |
Read speed
By one | All Virtual | All Direct | |
SQLite3 (file full) | 108965 | 553097 | 552364 |
SQLite3 (file off) | 110353 | 572344 | 546268 |
SQLite3 (file off exc) | 109490 | 626409 | 619348 |
SQLite3 (mem) | 107947 | 540715 | 583090 |
TObjectList (static) | 197300 | 951293 | 982318 |
TObjectList (virtual) | 193446 | 477646 | 955474 |
SQLite3 (ext full) | 114301 | 272925 | 542240 |
SQLite3 (ext off) | 121170 | 276900 | 546687 |
SQLite3 (ext off exc) | 115958 | 275664 | 554323 |
SQLite3 (ext mem) | 123974 | 290985 | 580383 |
WinHTTP SQLite3 (off exc) | 4248 | 250025 | 401316 |
Socket SQLite3 (off exc) | 8497 | 254245 | 421478 |