| date | 05.04.20 |
| kernel | 4.15.0-62 |
| ucode | 0xcc |
| SGX SDK | 1.8 |
| SGX mem | VNL mem | NTV | VNL | nnI | CnI | CFI | ||
|---|---|---|---|---|---|---|---|---|
| 100 | 1000000 INSERTs into table with no index | 65 | 70 | 2.451 | 5.131 | 4.727 | 4.797 | 4.74 |
| 110 | 1000000 ordered INSERTS with one index/PK | 144 | 154 | 3.241 | 7.201 | 6.308 | 6.43 | 6.38 |
| 120 | 1000000 unordered INSERTS with one index/PK | 222 | 237 | 3.962 | 8.069 | 9.671 | 9.516 | 9.799 |
| 130 | 25 SELECTS, numeric BETWEEN, unindexed | 222 | 237 | 1.442 | 4.412 | 3.99 | 4.021 | 4.013 |
| 140 | 10 SELECTS, LIKE, unindexed | 222 | 237 | 2 | 3.643 | 3.626 | 3.62 | 3.632 |
| 145 | 10 SELECTS w/ORDER BY and LIMIT, unindexed | 222 | 237 | 2.281 | 4.208 | 4.201 | 4.257 | 4.205 |
| 150 | CREATE INDEX five times | 425 | 453 | 2.764 | 17.714 | 22.133 | 25.469 | 22.775 |
| 160 | 200000 SELECTS, numeric BETWEEN, indexed | 425 | 453 | 10.259 | 25.116 | 26.607 | 26.317 | 26.56 |
| 161 | 200000 SELECTS, numeric BETWEEN, PK | 425 | 453 | 10.109 | 24.642 | 25.994 | 25.312 | 26.155 |
| 170 | 200000 SELECTS, text BETWEEN, indexed | 425 | 453 | 5.149 | 29.788 | 21.275 | 16.821 | 15.743 |
| 180 | 1000000 INSERTS with three indexes | 581 | 621 | 3.743 | 19.857 | 17.205 | 12.563 | 17.419 |
| 190 | DELETE and REFILL one table | 589 | 629 | 3.948 | 20.417 | 21.83 | 19.107 | 22.485 |
| 210 | ALTER TABLE ADD COLUMN, and query | 589 | 629 | 0.076 | 0.583 | 0.177 | 0.217 | 0.178 |
| 230 | 200000 UPDATES, numeric BETWEEN, indexed | 601 | 642 | 12.014 | 54.473 | 31.229 | 31.229 | 31.427 |
| 240 | 1000000 UPDATES of individual rows | 601 | 642 | 4.881 | 52.704 | 23.005 | 19.912 | 23.215 |
| 250 | One big UPDATE of the whole 1000000-row table | 601 | 642 | 0.21 | 2.809 | 4.236 | 4.606 | 4.182 |
| 260 | Query added column after filling | 601 | 642 | 0.078 | 0.773 | 0.196 | 0.606 | 0.21 |
| 270 | 200000 DELETEs, numeric BETWEEN, indexed | 601 | 642 | 4.635 | 32.693 | 22.269 | 18.982 | 22.195 |
| 280 | 1000000 DELETEs of individual rows | 601 | 642 | 5.193 | 58.196 | 24.976 | 23.299 | 24.863 |
| 290 | Refill two 1000000-row tables using REPLACE | 601 | 642 | 6.777 | 43.848 | 47.733 | 30.597 | 48.75 |
| 300 | Refill a 1000000-row table using (b&1)==(a&1) | 601 | 642 | 4.124 | 17.56 | 23.212 | 20.255 | 24.036 |
| 310 | 200000 four-ways joins | 601 | 642 | 10.327 | 267.313 | 51.564 | 43.955 | 52.141 |
| 320 | subquery in result set | 601 | 642 | 40.898 | 121.829 | 116 | 114.161 | 117.177 |
| 980 | PRAGMA integrity_check | 601 | 642 | 7.075 | 61.869 | 49.983 | 30.142 | 50.633 |
| 990 | ANALYZE | 601 | 642 | 0.549 | 4.304 | 1.767 | 1.989 | 1.772 |
| TOTAL | 148.186 | 889.152 | 563.914 | 498.18 | 564.685 |