Database Performance

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

The tests are executed on Windows 11 Home (version 10.0.26200.6899) 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)
Windows 32-bit	VCL	DBExpress 3.8.10.2
Windows 32-bit	VCL	FireDAC 3.42.0
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. sec
Run 03 - 1. sec
Run 04 - 1. sec
Run 05 - 1. sec
Run 06 - 1. sec
Run 07 - 1. sec
Run 08 - 1. sec
Run 09 - 1. sec
Run 10 - 1. sec