Table 5 Query benchmark
From: Archetype relational mapping - a practical openEHR persistence solution
Query | IV (ms) | ARM (ms) | Node + Path (ms) |
|---|---|---|---|
Query 1.1 | 80 (+74 %) | 46 | 5017 |
Query 1.2 | 91 (+54 %) | 59 | 5121 |
Query 1.3 | 196 (+15 %) | 170 | 5358 |
Query 2.1 | 221 (+16 %) | 191 | 24866 |
Query 2.2 | 219 (+17 %) | 187 | 25094 |
Query 2.3 | 474 (+129 %) | 207 | 26158 |
Query 3.1 | 242 | 270 (+12 %) | 294774 |
Query 3.2 | 224 | 299 (+33 %) | 297388 |
Query 3.3 | 254 | 411 (+62 %) | 362950 |
Query 4.1 | 198 (+13 %) | 176 | 127547 |
Query 4.2 | 254 (+32 %) | 193 | 128508 |
Query 4.3 | 1249 (+57 %) | 797 | 129901 |
Query 5.1 | 113 | 186 (+65 %) | 328181 |
Query 5.2 | 125 | 205 (+64 %) | 329097 |
Query 5.3 | 139 | 239 (+72 %) | 388727 |
Query 6.1 | 14596 (+5150 %) | 278 | 5746 |
Query 6.2 | 16340 (+5293 %) | 303 | 6029 |
Query 6.3 | 16453 (+5140 %) | 314 | 6984 |
Query 7.1 | 14582 (+1028 %) | 1293 | 41217 |
Query 7.2 | 14649 (+669 %) | 1904 | 53352 |