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 |
| Delete |
Optimized |
1 |
1.8989 ms |
1.886 ms |
1.444 ms |
1.641 ms |
1.913 ms |
2.078 ms |
2.342 ms |
| Delete |
Optimized |
10 |
2.5410 ms |
2.597 ms |
2.052 ms |
2.366 ms |
2.512 ms |
2.824 ms |
3.228 ms |
| Delete |
Optimized |
25 |
2.6786 ms |
2.700 ms |
2.063 ms |
2.439 ms |
2.705 ms |
2.993 ms |
3.719 ms |
| Delete |
Optimized |
50 |
2.9083 ms |
2.978 ms |
2.433 ms |
2.764 ms |
2.889 ms |
3.210 ms |
3.762 ms |
| Delete |
Optimized |
100 |
3.5568 ms |
3.575 ms |
2.765 ms |
3.171 ms |
3.577 ms |
3.808 ms |
4.739 ms |
| Delete |
Optimized |
1000 |
12.1008 ms |
12.496 ms |
10.181 ms |
11.190 ms |
12.049 ms |
13.033 ms |
19.642 ms |
| Delete |
Optimized |
10000 |
256.7395 ms |
258.544 ms |
169.748 ms |
198.522 ms |
247.292 ms |
306.970 ms |
364.708 ms |
| Delete |
Optimized Dapper |
1 |
2.3085 ms |
2.328 ms |
1.551 ms |
2.147 ms |
2.298 ms |
2.457 ms |
3.141 ms |
| Delete |
Optimized Dapper |
10 |
2.3796 ms |
2.470 ms |
1.931 ms |
2.141 ms |
2.349 ms |
2.729 ms |
3.368 ms |
| Delete |
Optimized Dapper |
25 |
2.6172 ms |
2.843 ms |
2.173 ms |
2.423 ms |
2.628 ms |
3.050 ms |
4.830 ms |
| Delete |
Optimized Dapper |
50 |
3.0626 ms |
3.187 ms |
2.312 ms |
2.742 ms |
3.026 ms |
3.471 ms |
5.228 ms |
| Delete |
Optimized Dapper |
100 |
3.9781 ms |
4.032 ms |
3.235 ms |
3.549 ms |
3.918 ms |
4.499 ms |
5.135 ms |
| Delete |
Optimized Dapper |
1000 |
12.3437 ms |
12.527 ms |
10.883 ms |
11.820 ms |
12.341 ms |
12.989 ms |
15.696 ms |
| Delete |
Optimized Dapper |
10000 |
189.6329 ms |
206.209 ms |
160.622 ms |
177.592 ms |
183.583 ms |
224.641 ms |
346.764 ms |
| Delete |
EF Core |
1 |
2.5783 ms |
2.627 ms |
1.958 ms |
2.254 ms |
2.475 ms |
3.050 ms |
3.966 ms |
| Delete |
EF Core |
10 |
2.8142 ms |
2.876 ms |
2.305 ms |
2.546 ms |
2.741 ms |
3.237 ms |
4.201 ms |
| Delete |
EF Core |
25 |
16.1706 ms |
24.484 ms |
2.743 ms |
3.605 ms |
4.421 ms |
50.819 ms |
106.800 ms |
| Delete |
EF Core |
50 |
18.8205 ms |
26.003 ms |
3.396 ms |
4.144 ms |
5.814 ms |
52.464 ms |
101.685 ms |
| Delete |
EF Core |
100 |
28.4838 ms |
31.610 ms |
4.657 ms |
5.180 ms |
29.374 ms |
52.592 ms |
105.427 ms |
| Delete |
EF Core |
1000 |
24.0095 ms |
24.152 ms |
22.458 ms |
23.549 ms |
23.912 ms |
24.578 ms |
27.351 ms |
| Delete |
EF Core |
10000 |
236.7108 ms |
237.784 ms |
230.121 ms |
233.864 ms |
236.058 ms |
240.862 ms |
253.160 ms |