Performance benchmarks

Data load performance

Data load performance is the time taken to persist a loaded dataset to storage.

Test Dataset: ECB Exchange Rates (ECB, EXR, 1.0)

3633 series
1,207,654 observations

Datastore: Registry Managed Database

Database	Registry Environment	Datastore Database Environment	Load time
MySQL 8.0	Linux, Core i5, 16 GB, SATA HDD 7200rpm storage	(same platform as the Registry)	424 seconds
MySQL 8.0	Linux, Core i5, 16 GB, SATA SSD storage	(same platform as the Registry)	64 seconds
MySQL 5.7	Windows 10, Core i7, 32GB, PCS PCIe M.2 SSD NVME (2000 MB/R, 1100 MB/W) storage	(same platform as the Registry)	23 seconds
MySQL 5.7	Linux, Core i7, 16GB, EVO PLUS M.2, PCIe NVMe (up to 3500MB/R, 3200MB/W) storage	(same platform as the Registry)	(tbc)

Datastore: Registry Managed Database

Database	Registry Environment	Operating Database Environment	Load time
MySQL 8.0	Linux, Core i5, 16 GB, SATA SSD storage	(same platform as the Registry)	11 seconds
MySQL 5.7	Windows 10, Core i7, 32GB, PCS PCIe M.2 SSD NVME (2000 MB/R, 1100 MB/W) storage	(same platform as the Registry)	6 seconds
MySQL 5.7	Linux, Core i7, 16GB, EVO PLUS M.2, PCIe NVMe (up to 3500MB/R, 3200MB/W) storage	(same platform as the Registry)	(tbc)