This solution was created to support of my article "A detailed look at EF Core’s JSON Columns feature" . Read the article for more infomation.
Task name
What is does
1. Add
Add N sample data to an empty SQL database
2. Read
Read N sample data from the SQL database
3. Order
Read N sample data and order the books using their star rating
4. Author
Find all the books that has a specific author’s name in the N sample data
10, 100: Simple, only showing the tasks that work One Author per book
10 books | 100 books
10 Authors | 100 Authors
0 Find book | 0 Find book
0 Reviews | 0 Reviews
0 Promotions | 0 Promotions
Method
NumBooks
Mean
Error
StdDev
AddSql
10
489,463.1 us
22,264.82 us
33,324.93 us
AddJson
10
445,212.8 us
19,245.94 us
28,806.42 us
ReadSql
10
646.1 us
4.42 us
6.47 us
ReadJson
10
604.3 us
12.50 us
18.32 us
AddSql
100
483,833.7 us
19,888.58 us
29,768.29 us
AddJson
100
460,351.0 us
20,565.71 us
30,781.78 us
ReadSql
100
1,164.7 us
28.04 us
41.97 us
ReadJson
100
2,105.1 us
14.26 us
20.90 us
10 books | 100 books | 1000 books
20 Authors | 200 Authors | 2000 Authors
10 Find book | 10 Authors books | 10 Authors books
20 Reviews | 200 Reviews | 2000 Reviews
1 Promotions | 10 Promotions | 100 Promotions
Method
NumBooks
Mean
Error
StdDev
AddSql
10
484,560.7 us
21,045.04 us
31,499.23 us
AddJson
10
465,823.8 us
20,801.46 us
31,134.65 us
ReadSql
10
872.1 us
8.35 us
12.25 us
ReadJson
10
782.5 us
13.69 us
19.19 us
OrderSql
10
960.9 us
11.75 us
17.58 us
OrderJson
10
750.2 us
5.83 us
8.55 us
AuthorSql
10
490.1 us
19.80 us
29.64 us
AuthorJson
10
572.4 us
30.40 us
45.50 us
AddSql
100
527,989.4 us
21,540.53 us
32,240.85 us
AddJson
100
507,386.9 us
25,168.28 us
36,891.34 us
ReadSql
100
1,819.9 us
41.26 us
60.47 us
ReadJson
100
14,299.6 us
183.66 us
263.41 us
OrderSql
100
1,915.2 us
20.51 us
28.08 us
OrderJson
100
13,786.0 us
86.24 us
123.69 us
AuthorSql
100
569.3 us
22.49 us
33.66 us
AuthorJson
100
1,099.5 us
7.74 us
11.58 us
AddSql
1000
1,841,422.6 us
22,380.39 us
32,804.89 us
AddJson
1000
982,724.1 us
27,639.94 us
40,514.27 us
ReadSql
1000
16,409.8 us
69.89 us
100.24 us
ReadJson
1000
155,170.5 us
1,934.49 us
2,835.55 us
OrderSql
1000
21,807.2 us
208.52 us
299.05 us
OrderJson
1000
153,265.9 us
1,144.50 us
1,677.59 us
AuthorSql
1000
795.0 us
12.47 us
18.66 us
AuthorJson
1000
6,123.1 us
62.10 us
87.05 us