# 300s HDD加载时间 load大约8小时。 # 300s HDD执行时间 | Case | Time(s) | Comment | | :---: | ------: | ------- | | 1 | 27.3 | | | 2 | 2.7 | | | 3 | 42.6 | | | 4 | 5.9 | | | 5 | 59.4 | | | 6 | 0.9 | | | 7 | 3.0 | | | 8 | 10.9 | | | 9 | 26.4 | | | 10 | 80.1 | | | 11 | 17.5 | 无limit | | 12 | 32.4 | | | 13 | 19.8 | | | 14 | 7.6 | | | 15 | 42.7 | | | 16 | 4.8 | 无limit | | 17 | 6.4 | | | 18 | 30.4 | | | 19 | 6.3 | | | 20 | 28.8 | 无limit | | 21 | 26.8 | | | 22 | 2.6 | | | Total | 486.1 | | # 1000s HDD加载时间 | 表 | 行数 | 时间(h) | | -------- | ---------- | --------- | | customer | 150000000 | | | part | 200000000 | | | partsupp | 800000000 | | | region | 5 | 0 | | nation | 25 | 0 | | lineitem | 5999989709 | 18.6 | | orders | 1500000000 | 5.8 | | supplier | 10000000 | 139(s) | # 1000s SSD执行时间 | Case | Time(s) | Comment | | ----- | ------- | ------- | | 1 | 4.4 | | | 2 | 1.4 | | | 3 | 18.3 | | | 4 | 6.6 | | | 5 | 9.5 | | | 6 | 0.8 | | | 7 | 9.2 | | | 8 | 9.8 | | | 9 | 39.9 | | | 10 | 40.0 | | | 11 | 3.5 | | | 12 | 49.4 | | | 13 | 61.3 | | | 14 | 56.5 | | | 15 | 7.5 | | | 16 | 12.1 | | | 17 | 7.6 | | | 18 | 43.8 | | | 19 | 2.3 | | | 20 | 7.9 | | | 21 | 23.6 | | | 22 | 8.5 | | | Total | 423.4 | |