Table 3.
Numbers related to the process of creating 3 reports of different complexities with the data warehouse.
| Report and details | Hospital A | Hospital B | Hospital C | Hospital D | |||
| Report 1 | |||||||
|
|
Rows, n | 4 | 4 | 4 | 4 | ||
|
|
Columns, n | 2 | 2 | 2 | 2 | ||
|
|
Solr queries, n | 8 | 8 | 8 | 8 | ||
|
|
Timea (ms), mean (SD) | 79.5 (111.6) | 185.3 (264.0) | 90.3 (117.3) | 95.3 (180.7) | ||
|
|
Total time | 645 ms | 1 s 489 ms | 728 ms | 767 ms | ||
| Report 2 | |||||||
|
|
Rows, n | 4 | 4 | 4 | 4 | ||
|
|
Columns, n | 12 | 12 | 12 | 12 | ||
|
|
Solr queries, n | 48 | 48 | 48 | 48 | ||
|
|
Timea (ms), mean (SD) | 18.3 (7.7) | 67.8 (23.3) | 22.6 (12.4) | 21.8 (13.7) | ||
|
|
Total time | 904 ms | 3 s 275 ms | 1 s 110 ms | 1 s 69 ms | ||
| Report 3 | |||||||
|
|
Rows, n | 48 | 804 | 396 | 2054 | ||
|
|
Columns, n | 4 | 4 | 4 | 4 | ||
|
|
Solr queries, n | 192 | 3216 | 1584 | 8216 | ||
|
|
Timea (ms), mean (SD) | 11.6 (4.2) | 25.1 (3.2) | 9.1 (3.4) | 9.8 (3.3) | ||
|
|
Total time | 2 s 315 ms | 82 s 233 ms | 15 s 201 ms | 84 s 758 ms | ||
aAverage time for the execution of each Solr query.