Skip to main content

Advertisement

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
  1. The percentage values in IV and ARM columns are more time spent on each query in the slower database than the faster database. The Node + Path database is not included in the calculation