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
Firebird3 : .NET 6.0.7 (6.0.722.32202), X64 RyuJIT
Job=Firebird3 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 |
11.4826 ms |
11.95 ms |
7.294 ms |
10.063 ms |
11.12 ms |
13.90 ms |
19.30 ms |
| Insert |
Optimized |
10 |
35.2538 ms |
35.95 ms |
26.078 ms |
31.763 ms |
34.93 ms |
38.49 ms |
52.35 ms |
| Insert |
Optimized |
25 |
66.3508 ms |
67.65 ms |
51.958 ms |
60.756 ms |
65.87 ms |
74.70 ms |
92.53 ms |
| Insert |
Optimized |
50 |
113.4318 ms |
114.58 ms |
92.077 ms |
108.081 ms |
113.78 ms |
118.15 ms |
150.68 ms |
| Insert |
Optimized |
100 |
226.3966 ms |
228.36 ms |
205.637 ms |
217.176 ms |
226.05 ms |
236.50 ms |
270.68 ms |
| Insert |
Optimized |
1000 |
2,194.1333 ms |
2,206.53 ms |
2,020.806 ms |
2,154.106 ms |
2,188.93 ms |
2,240.81 ms |
2,583.50 ms |
| Insert |
Optimized Dapper |
1 |
10.9644 ms |
11.49 ms |
7.742 ms |
9.812 ms |
10.88 ms |
12.75 ms |
17.14 ms |
| Insert |
Optimized Dapper |
10 |
31.3989 ms |
31.88 ms |
23.368 ms |
26.916 ms |
31.85 ms |
34.72 ms |
46.60 ms |
| Insert |
Optimized Dapper |
25 |
60.9546 ms |
61.16 ms |
50.712 ms |
58.410 ms |
60.94 ms |
64.75 ms |
70.70 ms |
| Insert |
Optimized Dapper |
50 |
114.1866 ms |
114.52 ms |
94.405 ms |
110.501 ms |
113.98 ms |
119.43 ms |
134.00 ms |
| Insert |
Optimized Dapper |
100 |
213.6337 ms |
213.86 ms |
188.205 ms |
208.397 ms |
212.97 ms |
221.24 ms |
240.28 ms |
| Insert |
Optimized Dapper |
1000 |
2,195.8405 ms |
2,219.49 ms |
1,992.607 ms |
2,111.810 ms |
2,179.83 ms |
2,308.65 ms |
2,548.19 ms |
| Insert |
EF Core |
1 |
13.5644 ms |
13.89 ms |
9.149 ms |
12.570 ms |
13.33 ms |
14.72 ms |
22.66 ms |
| Insert |
EF Core |
10 |
45.2811 ms |
46.48 ms |
39.836 ms |
43.269 ms |
45.11 ms |
47.68 ms |
66.11 ms |
| Insert |
EF Core |
25 |
103.2292 ms |
105.81 ms |
86.997 ms |
95.919 ms |
100.83 ms |
117.68 ms |
139.11 ms |
| Insert |
EF Core |
50 |
188.8810 ms |
187.97 ms |
162.087 ms |
182.478 ms |
188.82 ms |
195.20 ms |
206.76 ms |
| Insert |
EF Core |
100 |
371.1052 ms |
373.70 ms |
329.330 ms |
358.527 ms |
371.38 ms |
380.56 ms |
469.42 ms |
| Insert |
EF Core |
1000 |
3,684.3204 ms |
3,695.91 ms |
3,493.380 ms |
3,636.000 ms |
3,674.48 ms |
3,764.22 ms |
4,002.10 ms |