Performance benchmarks

From Fusion Registry Wiki
Revision as of 09:02, 16 August 2021 by Glenn (talk | contribs) (Created page with "=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<br>...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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)