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
SqlServer : .NET 6.0.7 (6.0.722.32202), X64 RyuJIT
Job=SqlServer 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 |
| Delete |
Optimized |
1 |
3.9535 ms |
4.086 ms |
2.941 ms |
3.448 ms |
3.974 ms |
4.560 ms |
5.790 ms |
| Delete |
Optimized |
10 |
4.3159 ms |
4.435 ms |
3.426 ms |
3.777 ms |
4.292 ms |
4.945 ms |
6.243 ms |
| Delete |
Optimized |
25 |
4.9292 ms |
5.024 ms |
3.516 ms |
4.478 ms |
4.919 ms |
5.502 ms |
6.597 ms |
| Delete |
Optimized |
50 |
5.9206 ms |
5.997 ms |
4.914 ms |
5.405 ms |
5.887 ms |
6.502 ms |
7.478 ms |
| Delete |
Optimized |
100 |
8.0936 ms |
8.917 ms |
6.638 ms |
7.395 ms |
7.812 ms |
9.196 ms |
14.806 ms |
| Delete |
Optimized |
1000 |
42.8684 ms |
44.889 ms |
32.292 ms |
34.789 ms |
40.229 ms |
53.655 ms |
70.429 ms |
| Delete |
Optimized |
10000 |
406.1837 ms |
400.701 ms |
324.241 ms |
390.542 ms |
407.425 ms |
419.270 ms |
444.329 ms |
| Delete |
Optimized Dapper |
1 |
4.1195 ms |
4.149 ms |
3.083 ms |
3.806 ms |
4.100 ms |
4.415 ms |
5.499 ms |
| Delete |
Optimized Dapper |
10 |
4.2213 ms |
4.346 ms |
3.384 ms |
3.862 ms |
4.162 ms |
4.647 ms |
6.648 ms |
| Delete |
Optimized Dapper |
25 |
4.9871 ms |
5.110 ms |
4.177 ms |
4.593 ms |
5.002 ms |
5.495 ms |
7.399 ms |
| Delete |
Optimized Dapper |
50 |
6.5087 ms |
6.678 ms |
5.158 ms |
5.773 ms |
6.376 ms |
7.527 ms |
9.898 ms |
| Delete |
Optimized Dapper |
100 |
8.0184 ms |
8.224 ms |
6.517 ms |
7.309 ms |
8.020 ms |
8.525 ms |
13.447 ms |
| Delete |
Optimized Dapper |
1000 |
46.9967 ms |
48.945 ms |
32.111 ms |
34.676 ms |
48.750 ms |
55.896 ms |
90.019 ms |
| Delete |
Optimized Dapper |
10000 |
407.9321 ms |
403.523 ms |
319.520 ms |
391.786 ms |
408.458 ms |
421.995 ms |
450.741 ms |
| Delete |
EF Core |
1 |
6.0226 ms |
6.223 ms |
4.461 ms |
5.486 ms |
5.837 ms |
7.004 ms |
9.502 ms |
| Delete |
EF Core |
10 |
6.3085 ms |
6.336 ms |
4.403 ms |
5.501 ms |
6.264 ms |
7.168 ms |
8.621 ms |
| Delete |
EF Core |
25 |
5.9871 ms |
6.185 ms |
4.635 ms |
5.519 ms |
5.956 ms |
6.624 ms |
10.089 ms |
| Delete |
EF Core |
50 |
8.7274 ms |
8.814 ms |
6.882 ms |
8.089 ms |
8.729 ms |
9.411 ms |
11.338 ms |
| Delete |
EF Core |
100 |
11.0407 ms |
11.011 ms |
8.717 ms |
10.518 ms |
11.071 ms |
11.490 ms |
12.858 ms |
| Delete |
EF Core |
1000 |
51.5999 ms |
51.611 ms |
47.140 ms |
49.898 ms |
51.257 ms |
53.599 ms |
58.050 ms |
| Delete |
EF Core |
10000 |
467.6815 ms |
467.331 ms |
441.935 ms |
463.052 ms |
468.081 ms |
471.721 ms |
482.736 ms |