Table 2 Response times in seconds of the six queries performed on MySQL relational ORM database
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 |