BenchmarkDotNet=v0.13.1, OS=Windows 10.0.19044.1826 (21H2)
12th Gen Intel Core i9-12900HK, 1 CPU, 20 logical and 14 physical cores
.NET SDK=6.0.302
[Host] : .NET 6.0.7 (6.0.722.32202), X64 RyuJIT
Postgres : .NET 6.0.7 (6.0.722.32202), X64 RyuJIT
Job=Postgres EvaluateOverhead=True OutlierMode=RemoveUpper
InvocationCount=1 IterationCount=20 LaunchCount=3
RunStrategy=ColdStart UnrollFactor=1 WarmupCount=0
| Method |
Variant |
Rows |
MeanNoOut |
Mean |
Min |
Q1 |
Median |
Q3 |
Max |
| Insert |
Optimized |
1 |
2.3656 ms |
2.412 ms |
2.075 ms |
2.244 ms |
2.350 ms |
2.510 ms |
3.150 ms |
| Insert |
Optimized |
10 |
2.8401 ms |
2.843 ms |
1.903 ms |
2.540 ms |
2.822 ms |
3.127 ms |
4.135 ms |
| Insert |
Optimized |
25 |
3.0933 ms |
3.078 ms |
1.999 ms |
2.566 ms |
3.056 ms |
3.468 ms |
4.357 ms |
| Insert |
Optimized |
50 |
4.1214 ms |
4.137 ms |
2.856 ms |
3.333 ms |
4.251 ms |
4.810 ms |
5.559 ms |
| Insert |
Optimized |
100 |
5.4185 ms |
5.404 ms |
4.274 ms |
4.763 ms |
5.557 ms |
5.894 ms |
7.030 ms |
| Insert |
Optimized |
1000 |
22.4976 ms |
22.508 ms |
20.831 ms |
21.890 ms |
22.498 ms |
22.923 ms |
25.277 ms |
| Insert |
Optimized |
10000 |
305.6074 ms |
311.089 ms |
249.428 ms |
291.697 ms |
301.463 ms |
335.224 ms |
399.303 ms |
| Insert |
Optimized Dapper |
1 |
2.2344 ms |
2.385 ms |
1.661 ms |
1.849 ms |
2.162 ms |
2.820 ms |
4.159 ms |
| Insert |
Optimized Dapper |
10 |
2.6411 ms |
2.586 ms |
1.750 ms |
2.381 ms |
2.637 ms |
2.798 ms |
3.152 ms |
| Insert |
Optimized Dapper |
25 |
3.1791 ms |
3.136 ms |
2.595 ms |
2.858 ms |
3.219 ms |
3.329 ms |
3.697 ms |
| Insert |
Optimized Dapper |
50 |
4.1620 ms |
4.130 ms |
2.963 ms |
3.441 ms |
4.176 ms |
4.586 ms |
6.479 ms |
| Insert |
Optimized Dapper |
100 |
5.1643 ms |
5.271 ms |
4.125 ms |
4.655 ms |
5.172 ms |
5.668 ms |
7.264 ms |
| Insert |
Optimized Dapper |
1000 |
22.9521 ms |
23.012 ms |
21.068 ms |
22.049 ms |
22.992 ms |
23.951 ms |
26.014 ms |
| Insert |
Optimized Dapper |
10000 |
304.5999 ms |
307.580 ms |
240.039 ms |
293.419 ms |
302.149 ms |
327.096 ms |
365.087 ms |
| Insert |
EF Core |
1 |
3.4271 ms |
3.444 ms |
2.712 ms |
3.037 ms |
3.446 ms |
3.777 ms |
4.466 ms |
| Insert |
EF Core |
10 |
19.3167 ms |
26.037 ms |
2.805 ms |
4.101 ms |
6.362 ms |
52.623 ms |
106.373 ms |
| Insert |
EF Core |
25 |
31.7289 ms |
32.908 ms |
4.118 ms |
6.370 ms |
49.079 ms |
54.598 ms |
102.402 ms |
| Insert |
EF Core |
50 |
21.2813 ms |
28.481 ms |
4.803 ms |
5.910 ms |
8.443 ms |
55.861 ms |
101.597 ms |
| Insert |
EF Core |
100 |
41.6823 ms |
41.369 ms |
6.401 ms |
8.858 ms |
55.045 ms |
62.790 ms |
103.798 ms |
| Insert |
EF Core |
1000 |
42.1696 ms |
42.563 ms |
37.716 ms |
40.541 ms |
41.907 ms |
44.086 ms |
50.444 ms |
| Insert |
EF Core |
10000 |
453.1988 ms |
453.461 ms |
421.179 ms |
446.403 ms |
451.770 ms |
461.210 ms |
481.747 ms |