Database Performance

This documents the alternative drivers used in MTG Studio for database acceess.

The tests are executed on

Machine: Asus ROG Flow Z13 16GB ram, i5-125000H (2.5 GHz), 12 Cores, 16 Logical Processors
Card Pool size: 110'024 cards
The application was run 10 in Release mode without debug symbols with UPX compression and stripped reallocation table.

Target Platform	Lib	Database Driver	Executable Size (KB)	Memory Footprint (MB)	AvgTime to Load All Cards (seconds)	Commment
Windows 32-bit	VCL	Mormot 3.40.0	15281	284.9	1.029	Default driver
Windows 32-bit	VCL	Mormot 3.7.2	15009 (-272)	284.7 (-0.200)	1.100 (+0.071 slower)	200 KB memory gain but 71 msec slower and lacks latest SQL features
Windows 32-bit	VCL	DBExpress 3.8.10.2	15132 (-149)	285.0 (+0.100)	1.912 (+0.883 slower)	significantly slower
Windows 32-bit	VCL	FireDAC 3.42.0	15718 (+437)	284.2 (-0.700)	1.728 (+0.699 slower)	memory is decreased, slow start
Windows 64-bit	VCL	DBExpress ?
Windows 64-bit	VCL	FireDAC ?
Windows 64-bit	FMX	DBExpress ?
Windows 64-bit	FMX	FireDAC ?
Windows 64-bit	FMX	DBExpress ?
Windows 64-bit	FMX	FireDAC ?

Windows 32-bit - VCL - Mormot 3.40.0
Run 01 - 1.06 sec
Run 02 - 1.09 sec
Run 03 - 1.03 sec
Run 04 - 1.02 sec
Run 05 - 1.02 sec
Run 06 - 1.00 sec
Run 07 - 1.03 sec
Run 08 - 1.02 sec
Run 09 - 1.00 sec
Run 10 - 1.02 sec

Windows 32-bit - VCL - Mormot 3.7.2
Run 01 - 1.13 sec
Run 02 - 1.11 sec
Run 03 - 1.11 sec
Run 04 - 1.11 sec
Run 05 - 1.08 sec
Run 06 - 1.09 sec
Run 07 - 1.09 sec
Run 08 - 1.11 sec
Run 09 - 1.08 sec
Run 10 - 1.09 sec

Windows 32-bit - VCL - DBExpress 3.8.10.2
Run 01 - 1.94 sec
Run 02 - 1.89 sec
Run 03 - 1.86 sec
Run 04 - 1.89 sec
Run 05 - 1.94 sec
Run 06 - 1.88 sec
Run 07 - 1.97 sec
Run 08 - 1.89 sec
Run 09 - 1.91 sec
Run 10 - 1.95 sec

Windows 32-bit - VCL - FireDAC 3.42.0
Run 01 - 1.72 sec
Run 02 - 1.72 sec
Run 03 - 1.74 sec
Run 04 - 1.72 sec
Run 05 - 1.72 sec
Run 06 - 1.73 sec
Run 07 - 1.72 sec
Run 08 - 1.72 sec
Run 09 - 1.74 sec
Run 10 - 1.75 sec