Performance tests using Synopse mORMot framework 1.18.6327

perftests.htm

Running tests using Synopse mORMot framework 1.18.6327, compiled with Delphi 7 32 bit, against SQLite 3.36.0, at 2021-09-30 08:50:05.
Insertion speed

 	Direct	Batch	Trans	Batch Trans
SQLite3 (file full)	64	3685	35459	104530
SQLite3 (file off)	620	33711	56636	220555
SQLite3 (file off exc)	2892	77737	55350	219394
SQLite3 (mem)	50741	206168	61736	306128
TObjectList (static)	147349	492513	150902	512295
TObjectList (virtual)	137038	487376	142344	463563
SQLite3 (ext full)	75	2104	40011	91079
SQLite3 (ext off)	903	22021	71255	209196
SQLite3 (ext off exc)	4994	70933	79870	210810
SQLite3 (ext mem)	71426	276014	84560	267222
WinHTTP SQLite3 (off exc)	3128	44374	9195	97420
Socket SQLite3 (off exc)	3711	42077	14718	106906

Read speed

 	By one	All Virtual	All Direct
SQLite3 (file full)	2324	547585	536711
SQLite3 (file off)	2101	544484	529604
SQLite3 (file off exc)	64707	580517	596587
SQLite3 (mem)	64693	563824	570580
TObjectList (static)	150629	943396	1097935
TObjectList (virtual)	148156	496031	1105705
SQLite3 (ext full)	93836	285975	564015
SQLite3 (ext off)	98561	290765	556668
SQLite3 (ext off exc)	95356	267665	708215
SQLite3 (ext mem)	92023	285013	570190
WinHTTP SQLite3 (off exc)	9420	252066	436833
Socket SQLite3 (off exc)	15178	256871	472143