-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbenchmarks.txt
More file actions
137 lines (127 loc) · 17.5 KB
/
Copy pathbenchmarks.txt
File metadata and controls
137 lines (127 loc) · 17.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
| Method | Mean | Error | StdDev | Ratio | RatioSD | Allocated | Alloc Ratio |
|------------------------------ |---------:|----------:|----------:|------:|--------:|----------:|------------:|
| 'Socigy (insert builder)' | 2.032 ms | 0.0698 ms | 0.2058 ms | 1.01 | 0.14 | 4.24 KB | 1.00 |
| 'Dapper (ExecuteAsync)' | 2.059 ms | 0.0698 ms | 0.2015 ms | 1.02 | 0.14 | 3.72 KB | 0.88 |
| 'EF Core (Add + SaveChanges)' | 2.743 ms | 0.1078 ms | 0.3179 ms | 1.36 | 0.21 | 66.01 KB | 15.56 |
| Method | Rows | Mean | Error | StdDev | Median | Ratio | RatioSD | Allocated | Alloc Ratio |
|----------------------------------- |----- |-------------:|-----------:|-----------:|-------------:|-------:|--------:|-----------:|------------:|
| 'Socigy (InsertMultipleAsync)' | 100 | 2.882 ms | 0.0993 ms | 0.2897 ms | 2.874 ms | 1.01 | 0.14 | 135.98 KB | 1.00 |
| 'Socigy (per-row loop, 1 tx)' | 100 | 30.857 ms | 0.6089 ms | 1.4588 ms | 30.934 ms | 10.81 | 1.18 | 232.94 KB | 1.71 |
| 'Dapper (ExecuteAsync over list)' | 100 | 141.808 ms | 2.5344 ms | 3.2954 ms | 142.512 ms | 49.68 | 5.02 | 154.29 KB | 1.13 |
| 'EF Core (AddRange + SaveChanges)' | 100 | 7.001 ms | 0.2512 ms | 0.7248 ms | 6.882 ms | 2.45 | 0.35 | 707.25 KB | 5.20 |
| | | | | | | | | | |
| 'Socigy (InsertMultipleAsync)' | 1000 | 6.669 ms | 0.1757 ms | 0.5071 ms | 6.593 ms | 1.01 | 0.11 | 1431.84 KB | 1.00 |
| 'Socigy (per-row loop, 1 tx)' | 1000 | 262.262 ms | 4.8929 ms | 12.6301 ms | 259.746 ms | 39.54 | 3.49 | 2314.19 KB | 1.62 |
| 'Dapper (ExecuteAsync over list)' | 1000 | 1,526.935 ms | 29.8312 ms | 70.3157 ms | 1,508.931 ms | 230.23 | 20.06 | 1525.29 KB | 1.07 |
| 'EF Core (AddRange + SaveChanges)' | 1000 | 23.868 ms | 4.1996 ms | 12.3825 ms | 16.015 ms | 3.60 | 1.88 | 6295.18 KB | 4.40 |
| Method | Mean | Error | StdDev | Gen0 | Allocated |
|------------------------------------------ |---------:|--------:|--------:|-------:|----------:|
| 'Socigy: expression -> parameterized SQL' | 447.0 ns | 8.51 ns | 8.74 ns | 0.0319 | 1.78 KB |
| Method | Rows | Mean | Error | StdDev | Ratio | RatioSD | Gen0 | Allocated |AAlloc Ratio |
|------------------------------------ |----- |---------:|---------:|---------:|------:|--------:|-------:|----------:|------------:|
| 'Socigy (.sql procedure)' | 1 | 314.3 us | 6.12 us | 6.29 us | 1.00 | 0.03 | - | 3.49 KB | 1.00 |
| 'Dapper (raw SQL)' | 1 | 304.1 us | 6.06 us | 11.39 us | 0.97 | 0.04 | - | 3.06 KB | 0.88 |
| 'EF Core (FromSqlRaw, no tracking)' | 1 | 408.0 us | 8.11 us | 9.66 us | 1.30 | 0.04 | 0.9766 | 58.85 KB | 16.89 |
| | | | | | | | | | |
| 'Socigy (.sql procedure)' | 100 | 383.7 us | 6.33 us | 5.92 us | 1.00 | 0.02 | - | 15.63 KB | 1.00 |
| 'Dapper (raw SQL)' | 100 | 371.0 us | 7.36 us | 21.34 us | 0.97 | 0.06 | - | 22.92 KB | 1.47 |
| 'EF Core (FromSqlRaw, no tracking)' | 100 | 506.4 us | 10.04 us | 15.02 us | 1.32 | 0.04 | 0.9766 | 89.57 KB | 5.73 |
| | | | | | | | | | |
| 'Socigy (.sql procedure)' | 1000 | 649.3 us | 12.12 us | 11.33 us | 1.00 | 0.02 | 1.9531 | 121.32 KB | 1.00 |
| 'Dapper (raw SQL)' | 1000 | 593.2 us | 10.97 us | 10.78 us | 0.91 | 0.02 | 1.9531 | 198.77 KB | 1.64 |
| 'EF Core (FromSqlRaw, no tracking)' | 1000 | 802.9 us | 15.82 us | 29.33 us | 1.24 | 0.05 | 3.9063 | 363.88 KB | 3.00 |
| Method | Rows | Mean | Error | StdDev | Median | Ratio | RatioSD | Gen0 | Allocated | Alloc Ratio |
|------------------------ |----- |-----------:|---------:|---------:|-----------:|------:|--------:|--------:|----------:|------------:|
| 'Socigy (typed Query)' | 1 | 350.7 us | 6.22 us | 9.12 us | 352.0 us | 1.00 | 0.04 | - | 4.61 KB | 1.00 |
| 'Dapper (raw SQL)' | 1 | 340.1 us | 6.66 us | 11.13 us | 342.0 us | 0.97 | 0.04 | - | 3.07 KB | 0.67 |
| 'EF Core (no tracking)' | 1 | 423.6 us | 8.22 us | 11.25 us | 422.6 us | 1.21 | 0.04 | 0.9766 | 56.38 KB | 12.23 |
| 'EF Core (tracking)' | 1 | 440.7 us | 8.78 us | 23.74 us | 434.3 us | 1.26 | 0.07 | 0.9766 | 56.36 KB | 12.22 |
| | | | | | | | | | | |
| 'Socigy (typed Query)' | 100 | 375.0 us | 6.89 us | 6.44 us | 373.7 us | 1.00 | 0.02 | - | 16.74 KB | 1.00 |
| 'Dapper (raw SQL)' | 100 | 364.6 us | 7.19 us | 8.27 us | 363.2 us | 0.97 | 0.03 | - | 22.93 KB | 1.37 |
| 'EF Core (no tracking)' | 100 | 474.0 us | 9.24 us | 8.64 us | 475.0 us | 1.26 | 0.03 | 0.9766 | 87.1 KB | 5.20 |
| 'EF Core (tracking)' | 100 | 526.8 us | 10.42 us | 15.28 us | 529.1 us | 1.41 | 0.05 | 1.9531 | 147.96 KB | 8.84 |
| | | | | | | | | | | |
| 'Socigy (typed Query)' | 1000 | 611.1 us | 12.18 us | 34.36 us | 601.6 us | 1.00 | 0.08 | 1.9531 | 122.48 KB | 1.00 |
| 'Dapper (raw SQL)' | 1000 | 593.1 us | 11.70 us | 27.80 us | 594.6 us | 0.97 | 0.07 | 2.9297 | 198.76 KB | 1.62 |
| 'EF Core (no tracking)' | 1000 | 762.2 us | 15.24 us | 19.27 us | 763.3 us | 1.25 | 0.07 | 3.9063 | 361.45 KB | 2.95 |
| 'EF Core (tracking)' | 1000 | 1,166.4 us | 22.96 us | 28.20 us | 1,164.6 us | 1.91 | 0.11 | 15.6250 | 979.21 KB | 7.99 |
| Method | Mean | Error | StdDev | Median | Ratio | RatioSD | Allocated | Alloc Ratio |
|-------------------------- |---------:|----------:|----------:|---------:|------:|--------:|----------:|------------:|
| 'Socigy (update builder)' | 1.566 ms | 0.0310 ms | 0.0568 ms | 1.550 ms | 1.00 | 0.05 | 5.95 KB | 1.00 |
| 'Dapper (ExecuteAsync)' | 1.577 ms | 0.0311 ms | 0.0606 ms | 1.567 ms | 1.01 | 0.05 | 3.21 KB | 0.54 |
| 'EF Core (ExecuteUpdate)' | 1.660 ms | 0.0332 ms | 0.0897 ms | 1.624 ms | 1.06 | 0.07 | 58.16 KB | 9.77 |
| Method | Job | Runtime | Rows | Mean | Error | StdDev | Median | Ratio | RatioSD | Gen0 | Allocated | Alloc Ratio |
|----------------------------- |---------- |--------------- |----- |---------:|---------:|---------:|---------:|------:|--------:|-------:|----------:|------------:|
| 'Socigy (typed Query)' | JIT | .NET 10.0 | 1 | 357.5 us | 7.15 us | 14.76 us | 354.5 us | 1.00 | 0.06 | - | 4.61 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 1 | 320.8 us | 6.39 us | 16.62 us | 315.7 us | 0.90 | 0.06 | - | 2.58 KB | 0.56 |
| | | | | | | | | | | | | |
| 'Socigy (typed Query)' | NativeAOT | NativeAOT 10.0 | 1 | 321.9 us | 6.36 us | 17.50 us | 319.9 us | 1.00 | 0.08 | - | 4.87 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 1 | 301.1 us | 5.86 us | 5.20 us | 301.5 us | 0.94 | 0.05 | - | 2.6 KB | 0.53 |
| | | | | | | | | | | | | |
| 'Socigy (typed Query)' | JIT | .NET 10.0 | 100 | 395.7 us | 7.90 us | 9.40 us | 392.0 us | 1.00 | 0.03 | - | 16.73 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 100 | 352.1 us | 6.94 us | 9.02 us | 350.7 us | 0.89 | 0.03 | - | 14.7 KB | 0.88 |
| | | | | | | | | | | | | |
| 'Socigy (typed Query)' | NativeAOT | NativeAOT 10.0 | 100 | 364.1 us | 4.08 us | 3.41 us | 364.6 us | 1.00 | 0.01 | - | 17 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 100 | 387.4 us | 7.31 us | 13.37 us | 387.2 us | 1.06 | 0.04 | - | 14.72 KB | 0.87 |
| | | | | | | | | | | | | |
| 'Socigy (typed Query)' | JIT | .NET 10.0 | 1000 | 616.4 us | 12.28 us | 26.96 us | 613.7 us | 1.00 | 0.06 | 1.9531 | 122.45 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 1000 | 564.0 us | 9.55 us | 9.81 us | 562.9 us | 0.92 | 0.04 | 1.9531 | 120.4 KB | 0.98 |
| | | | | | | | | | | | | |
| 'Socigy (typed Query)' | NativeAOT | NativeAOT 10.0 | 1000 | 640.6 us | 12.11 us | 10.74 us | 639.6 us | 1.00 | 0.02 | 1.9531 | 122.69 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 1000 | 600.4 us | 11.93 us | 11.72 us | 599.8 us | 0.94 | 0.02 | 1.9531 | 120.46 KB | 0.98 |
| Method | Job | Runtime | Rows | Mean | Error | StdDev | Ratio | RatioSD | Gen0 | Allocated | Alloc Ratio |
|----------------------------- |---------- |--------------- |----- |---------:|---------:|---------:|------:|--------:|-------:|----------:|------------:|
| 'Socigy (.sql procedure)' | JIT | .NET 10.0 | 1 | 329.5 us | 6.55 us | 14.37 us | 1.00 | 0.06 | - | 3.5 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 1 | 336.3 us | 6.63 us | 15.36 us | 1.02 | 0.06 | - | 2.6 KB | 0.74 |
| | | | | | | | | | | | |
| 'Socigy (.sql procedure)' | NativeAOT | NativeAOT 10.0 | 1 | 303.7 us | 5.65 us | 5.01 us | 1.00 | 0.02 | - | 3.5 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 1 | 301.4 us | 5.93 us | 6.82 us | 0.99 | 0.03 | - | 2.63 KB | 0.75 |
| | | | | | | | | | | | |
| 'Socigy (.sql procedure)' | JIT | .NET 10.0 | 100 | 366.3 us | 6.85 us | 7.33 us | 1.00 | 0.03 | - | 15.61 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 100 | 351.4 us | 6.85 us | 6.73 us | 0.96 | 0.03 | - | 14.72 KB | 0.94 |
| | | | | | | | | | | | |
| 'Socigy (.sql procedure)' | NativeAOT | NativeAOT 10.0 | 100 | 354.4 us | 7.06 us | 8.93 us | 1.00 | 0.03 | - | 15.61 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 100 | 376.3 us | 7.43 us | 13.78 us | 1.06 | 0.05 | - | 14.71 KB | 0.94 |
| | | | | | | | | | | | |
| 'Socigy (.sql procedure)' | JIT | .NET 10.0 | 1000 | 585.5 us | 10.43 us | 10.71 us | 1.00 | 0.02 | 1.9531 | 121.32 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 1000 | 557.9 us | 10.99 us | 12.66 us | 0.95 | 0.03 | 1.9531 | 120.41 KB | 0.99 |
| | | | | | | | | | | | |
| 'Socigy (.sql procedure)' | NativeAOT | NativeAOT 10.0 | 1000 | 642.7 us | 9.45 us | 8.84 us | 1.00 | 0.02 | 1.9531 | 121.31 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 1000 | 591.1 us | 11.05 us | 10.33 us | 0.92 | 0.02 | 1.9531 | 120.42 KB | 0.99 |
| Method | Job | Runtime | Mean | Error | StdDev | Ratio | RatioSD | Allocated | Alloc Ratio |
|----------------------------- |---------- |--------------- |---------:|----------:|----------:|------:|--------:|----------:|------------:|
| 'Socigy (insert builder)' | JIT | .NET 10.0 | 2.149 ms | 0.0697 ms | 0.2043 ms | 1.01 | 0.13 | 4.55 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | JIT | .NET 10.0 | 1.981 ms | 0.0526 ms | 0.1526 ms | 0.93 | 0.11 | 3.33 KB | 0.73 |
| | | | | | | | | | |
| 'Socigy (insert builder)' | NativeAOT | NativeAOT 10.0 | 1.906 ms | 0.0547 ms | 0.1587 ms | 1.01 | 0.12 | 4.66 KB | 1.00 |
| 'Raw ADO.NET (hand-written)' | NativeAOT | NativeAOT 10.0 | 1.866 ms | 0.0652 ms | 0.1900 ms | 0.99 | 0.13 | 3.2 KB | 0.69 |
| Method | Rows | Mean | Error | StdDev | Ratio | RatioSD | Gen0 | Allocated | Alloc Ratio |
|-------------------------------------- |----- |---------:|---------:|---------:|------:|--------:|-------:|----------:|------------:|
| 'Socigy (typed Query, defined)' | 1 | 359.1 us | 7.16 us | 13.63 us | 1.00 | 0.05 | - | 4.62 KB | 1.00 |
| 'Socigy (DynamicTable, runtime name)' | 1 | 333.1 us | 6.51 us | 8.92 us | 0.93 | 0.04 | - | 5.71 KB | 1.24 |
| 'Dapper (raw SQL, runtime name)' | 1 | 325.0 us | 6.43 us | 10.38 us | 0.91 | 0.04 | - | 3.25 KB | 0.70 |
| 'EF Core (no tracking, static model)' | 1 | 464.7 us | 9.00 us | 23.55 us | 1.30 | 0.08 | 0.9766 | 56.53 KB | 12.25 |
| | | | | | | | | | |
| 'Socigy (typed Query, defined)' | 100 | 395.2 us | 7.87 us | 8.75 us | 1.00 | 0.03 | - | 16.73 KB | 1.00 |
| 'Socigy (DynamicTable, runtime name)' | 100 | 390.0 us | 7.76 us | 19.89 us | 0.99 | 0.05 | - | 17.89 KB | 1.07 |
| 'Dapper (raw SQL, runtime name)' | 100 | 373.3 us | 7.39 us | 6.55 us | 0.94 | 0.03 | - | 23.16 KB | 1.38 |
| 'EF Core (no tracking, static model)' | 100 | 505.7 us | 9.88 us | 14.79 us | 1.28 | 0.05 | 0.9766 | 87.25 KB | 5.21 |
| | | | | | | | | | |
| 'Socigy (typed Query, defined)' | 1000 | 602.9 us | 11.54 us | 29.78 us | 1.00 | 0.07 | 1.9531 | 122.41 KB | 1.00 |
| 'Socigy (DynamicTable, runtime name)' | 1000 | 697.4 us | 22.07 us | 65.07 us | 1.16 | 0.12 | 1.9531 | 123.44 KB | 1.01 |
| 'Dapper (raw SQL, runtime name)' | 1000 | 695.9 us | 12.20 us | 9.53 us | 1.16 | 0.06 | 1.9531 | 198.93 KB | 1.63 |
| 'EF Core (no tracking, static model)' | 1000 | 833.8 us | 16.37 us | 15.31 us | 1.39 | 0.07 | 5.8594 | 361.61 KB | 2.95 |
| Method | Rows | Mean | Error | StdDev | Ratio | RatioSD | Gen0 | Allocated | Alloc Ratio |
|----------------------------- |----- |-----------:|---------:|---------:|------:|--------:|-------:|----------:|------------:|
| 'Socigy (typed Join)' | 1 | 486.6 us | 9.44 us | 14.70 us | 1.00 | 0.04 | - | 14.43 KB | 1.00 |
| 'Dapper (multi-map join)' | 1 | 491.2 us | 11.15 us | 32.88 us | 1.01 | 0.07 | - | 3.94 KB | 0.27 |
| 'EF Core (no tracking join)' | 1 | 593.2 us | 8.74 us | 7.30 us | 1.22 | 0.04 | 0.9766 | 61.06 KB | 4.23 |
| | | | | | | | | | |
| 'Socigy (typed Join)' | 100 | 542.1 us | 10.54 us | 11.28 us | 1.00 | 0.03 | - | 34.53 KB | 1.00 |
| 'Dapper (multi-map join)' | 100 | 556.9 us | 12.90 us | 37.22 us | 1.03 | 0.07 | - | 37.46 KB | 1.08 |
| 'EF Core (no tracking join)' | 100 | 693.9 us | 13.65 us | 12.76 us | 1.28 | 0.03 | - | 100.99 KB | 2.93 |
| | | | | | | | | | |
| 'Socigy (typed Join)' | 1000 | 993.6 us | 19.81 us | 41.35 us | 1.00 | 0.06 | - | 217.82 KB | 1.00 |
| 'Dapper (multi-map join)' | 1000 | 903.6 us | 18.06 us | 38.49 us | 0.91 | 0.05 | 3.9063 | 339.82 KB | 1.56 |
| 'EF Core (no tracking join)' | 1000 | 1,179.2 us | 23.46 us | 27.01 us | 1.19 | 0.06 | 7.8125 | 459.77 KB | 2.11 |