Skip to main content

Table 2 Response times in seconds of the six queries performed on MySQL relational ORM database

From: Examining database persistence of ISO/EN 13606 standardized electronic health record extracts: relational vs. NoSQL approaches

ORM 5000 10,000 20,000 slope (*10 −6 )
Q1 0.0429 209.0284 1082.7872 72,182.95
Q2 101.6196 >10,000 >10,000 >>
Q3 0.1256 4.1982 12.6110 832.36
Q4 0.1843 400.6388 1598.7410 106,570.45
Q5 200.8954 >10,000 >10,000 >>
Q6 0.7362 65.1898 185.2420 12,300.39
Database size 4.8GB 9.7GB 19.8GB  
Total extracts 5000 10,000 20,000  
  1. *stands for the multiplication sign