Difference between revisions of "Performance benchmarks"
Jump to navigation
Jump to search
(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>...") |
(→Test Dataset: ECB Exchange Rates (ECB, EXR, 1.0)) |
||
| Line 10: | Line 10: | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
| − | ! Database !! Registry | + | ! Registry !! 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 | + | | 10.7.4 || 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 | + | | 10.7.4 || 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 | + | | 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 |
|- | |- | ||
| − | | 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) | + | | 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: | + | ===Datastore: Fusion Datastore (in memory datastore persisted to the operating database)=== |
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
| − | ! Database !! Registry | + | ! Registry !! Database !! Registry environment !! Datastore database environment !! Load time |
|- | |- | ||
| − | | MySQL 8.0 || Linux, Core i5, 16 GB, SATA SSD storage|| (same platform as the Registry)|| 11 seconds | + | | 10.7.4 || 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 | + | | 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 |
|- | |- | ||
| − | | 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) | + | | 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) |
|} | |} | ||
Revision as of 09:05, 16 August 2021
Contents
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) |
