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

Registry	Database	Registry environment	Datastore database environment	Load time
10.7.4	MySQL 8.0	Linux, Core i5, 16 GB, SATA HDD 7200rpm storage	(same platform as the Registry)	424 seconds
10.7.4	MySQL 8.0	Linux, Core i5, 16 GB, SATA SSD storage	(same platform as the Registry)	64 seconds
10.7.4	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
10.7.4	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: Fusion Datastore (in memory datastore persisted to the operating database)

Registry	Database	Registry environment	Datastore database environment	Load time
10.7.4	MySQL 8.0	Linux, Core i5, 16 GB, SATA SSD storage	(same platform as the Registry)	11 seconds
10.7.4	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
10.7.4	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)