Test Results

Performance across platforms and editions

Docker containers: CPU AMD Ryzen 5 5500U — 4 cores allocated • RAM 4 GB allocated per container • PostgreSQL 18 (pgdb) • SQL Server Developer (msdb) • Data ~15 000 objects, ~1 200 000 properties
mssql
mssql.pro
postgres
postgres.pro
ID
Example
Tier
MS
MS Pro
PG
PG Pro
E000
Bulk Insert - Complex Objects
Free
861ms(100)
1643ms(100)
2003ms(100)
1723ms(100)
E001
SaveAsync - Create Employee
Free
92ms
77ms
118ms
124ms
E002
LoadAsync - Load Employee by ID
Free
46ms
73ms
82ms
64ms
E010
Where - Filter by Salary
Free
1636ms(100)
230ms(100)
737ms(100)
194ms(100)
E011
Where - AND Condition
Free
1541ms(100)
164ms(100)
768ms(100)
140ms(100)
E012
Where - OR Condition
Free
1647ms(100)
146ms(100)
626ms(100)
122ms(100)
E013
Where - NOT Equal
Free
1632ms(100)
151ms(100)
551ms(100)
118ms(100)
E014
Where - Range Condition
Free
1904ms(100)
144ms(100)
592ms(100)
111ms(100)
E015
Where - Triple AND
Free
1638ms(100)
125ms(100)
706ms(100)
122ms(100)
E016
Where - Chained Filters
Free
1648ms(100)
111ms(100)
725ms(100)
125ms(100)
E020
Where - DateTime Greater
Free
1573ms(100)
83ms(100)
618ms(100)
105ms(100)
E021
Where - DateTime Range
Free
1600ms(100)
76ms(100)
983ms(100)
92ms(100)
E030
Where - String Contains
Free
1570ms(100)
81ms(100)
1102ms(100)
95ms(100)
E031
Where - String StartsWith
Free
1766ms(100)
94ms(100)
1115ms(100)
80ms(100)
E032
Where - Contains IgnoreCase
Free
1711ms(100)
80ms(100)
1030ms(100)
63ms(100)
E040
Where - Nested Property
Free
1615ms(100)
90ms(100)
656ms(100)
79ms(100)
E041
Where - Deep Nested Property
Pro
—
89ms(100)
—
81ms(100)
E050
Array Contains - Find by Skill
Free
1677ms(100)
258ms(100)
587ms(100)
76ms(100)
E051
Array Contains - Multiple OR
Free
1539ms(100)
134ms(100)
533ms(100)
71ms(100)
E052
Array NOT Contains
Free
1663ms(100)
114ms(100)
666ms(100)
71ms(100)
E053
Array Contains + Conditions
Free
1676ms(100)
128ms(100)
1088ms(100)
264ms(100)
E060
Dict ContainsKey - Phone Directory
Free
1544ms(100)
86ms(100)
930ms(100)
84ms(100)
E061
Dict Indexer - Bonus by Year
Free
1679ms(100)
74ms(100)
1135ms(100)
79ms(100)
E062
Dict - Nested Class Property
Free
1706ms(100)
164ms(100)
681ms(100)
127ms(100)
E063
Dict - Tuple Key
Free
1637ms(100)
104ms(100)
667ms(100)
104ms(100)
E070
CountAsync - Total and Filtered
Free
15ms(5603)
20ms(5086)
21ms(13769)
45ms(13977)
E071
AnyAsync - Check Existence
Free
4ms(1)
3ms(1)
4ms(1)
4ms(1)
E072
AnyAsync - With Predicate
Free
6ms(1)
44ms(1)
10ms(1)
32ms(1)
E073
AllAsync - Check All Match
Free
41ms(1)
95ms(1)
65ms(1)
138ms(1)
E074
WhereIn - Filter by List
Free
1616ms(3293)
197ms(2988)
1022ms(8171)
101ms(8293)
E075
Select - Projection
Free
13ms(100)
51ms(100)
53ms(100)
27ms(100)
E076
Distinct - Unique by Props
Free
1684ms(100)
70ms(100)
619ms(100)
51ms(100)
E080
OrderBy - Sort by Salary
Free
232ms(10)
—
200ms(10)
—
E081
OrderBy + ThenBy
Free
388ms(100)
—
289ms(100)
76ms(100)
E082
Skip/Take - Pagination
Free
71ms(10)
64ms(10)
562ms(10)
46ms(10)
E083
OrderByDescending - Reverse Sort
Free
270ms(10)
114ms(10)
202ms(10)
—
E087
Tree Cleanup - Remove All
Free
3ms(0)
9127ms(202)
16771ms(202)
16884ms(202)
E088
Tree Create BULK - Fast
Free
116ms(101)
244ms(101)
220ms(101)
221ms(101)
E089
Tree Create Sequential - Slow
Free
7038ms(101)
7786ms(101)
7074ms(101)
10190ms(101)
E090
Tree Load - Full Hierarchy
Free
341ms(101)
565ms(101)
209ms(101)
261ms(101)
E091
Tree Count - CountAsync
Free
5ms(404)
18ms(202)
9ms(202)
10ms(202)
E092
Tree Children - Direct
Free
22ms(10)
27ms(10)
15ms(10)
17ms(10)
E093
Tree Path - Breadcrumbs
Free
31ms(4)
109ms(4)
25ms(4)
43ms(4)
E094
Tree Descendants - All
Free
333ms(100)
436ms(100)
209ms(100)
247ms(100)
E095
Tree Move - Relocate Node
Free
54ms(1)
311ms(1)
41ms(1)
46ms(1)
E096
Tree Query - LINQ on Trees
Free
69ms(40)
60ms(20)
16ms(20)
32ms(20)
E097
Tree Query - Roots Only
Free
11ms(4)
28ms(2)
6ms(2)
6ms(2)
E098
Tree Query - Leaves Only
Free
371ms(320)
22ms(160)
77ms(160)
12ms(160)
E099
Tree Query - By Level
Free
72ms(50)
33ms(50)
52ms(95)
19ms(50)
E100
Tree Traversal - DFS
Free
0ms(101)
1ms(101)
1ms(96)
1ms(101)
E101
Tree Traversal - BFS
Free
0ms(101)
1ms(101)
1ms(96)
1ms(101)
E102
Tree - IsDescendantOf
Free
30ms(2)
57ms(2)
20ms(2)
38ms(2)
E103
Tree - IsAncestorOf
Free
27ms(2)
60ms(2)
20ms(2)
38ms(2)
E104
Tree - GetLevel
Free
40ms(3)
78ms(3)
26ms(3)
54ms(3)
E105
Tree Query - Scoped to Root
Free
31ms(25)
19ms(25)
19ms(30)
7ms(25)
E106
Tree Query - WhereChildrenOf
Free
15ms(10)
9ms(10)
9ms(10)
7ms(10)
E107
Tree Query - Multiple Roots
Free
56ms(50)
14ms(50)
32ms(55)
8ms(50)
E108
Tree Query - ToTreeListAsync
Free
22ms(5)
89ms(5)
25ms(5)
87ms(5)
E109
Tree Query - ToRootListAsync
Free
14ms(1)
25ms(1)
10ms(1)
14ms(1)
E110
Tree Query - WhereHasAncestor
Free
1837ms(160)
95ms(200)
69ms(240)
114ms(200)
E111
Tree Query - WhereHasDescendant
Free
88ms(40)
62ms(42)
37ms(20)
27ms(42)
E112
Tree - GetStats
Free
331ms(101)
408ms(101)
191ms(96)
280ms(101)
E113
Tree Query - ToFlatListAsync
Free
136ms(100)
68ms(100)
56ms(105)
25ms(100)
E114
List - Create
Free
16ms(1)
295ms(1)
525ms(1)
474ms(1)
E115
List - Add Items
Free
—
42ms(4)
18ms(4)
17ms(4)
E116
List - Get Items
Free
0ms(4)
2ms(4)
1ms(4)
1ms(4)
E117
ListItem - With Object
Free
96ms(1)
126ms(1)
94ms(1)
129ms(1)
E118
Props - ListItem Field
Free
96ms(1)
116ms(1)
97ms(1)
129ms(1)
E119
Props - List<ListItem>
Free
88ms(3)
105ms(3)
101ms(3)
126ms(3)
E120
ListItem - Where by Value
Free
9ms(2)
57ms(1)
9ms(1)
13ms(1)
E121
ListItem - WhereIn by Value
Free
10ms(2)
56ms(1)
8ms(1)
9ms(1)
E122
ListItem - Direct Compare
Free
15ms(2)
34ms(1)
7ms(1)
11ms(1)
E123
ListItem Array - Any
Free
11ms(2)
57ms(1)
10ms(1)
10ms(1)
E124
SumAsync - Total
Free
12ms(1)
37ms(1)
28ms(1)
33ms(1)
E125
AverageAsync - Mean
Free
7ms(1)
26ms(1)
22ms(1)
27ms(1)
E126
MinAsync/MaxAsync - Range
Free
23ms(2)
71ms(2)
45ms(2)
58ms(2)
E127
AggregateAsync - Batch
Free
147ms(5588)
117ms(5083)
46ms(13753)
45ms(13955)
E128
GroupBy - Simple
Free
52ms(6)
153ms(6)
128ms(6)
65ms(6)
E129
GroupBy - With Filter
Free
89ms(5)
563ms(5)
188ms(5)
43ms(5)
E130
GroupBy - Composite Key
Free
5377ms(6)
158ms(6)
91ms(7)
57ms(7)
E131
GroupByRedb - Base Fields
Free
17ms(1)
36ms(1)
35ms(1)
55ms(1)
E132
Window - RowNumber
Free
609ms(50)
397ms(50)
71ms(50)
76ms(50)
E133
Window - Running Sum
Free
366ms(50)
467ms(50)
76ms(50)
79ms(50)
E134
Window - Lag/Lead
Free
516ms(50)
409ms(50)
74ms(50)
63ms(50)
E135
Window - Rank/DenseRank
Free
389ms(50)
360ms(50)
52ms(50)
61ms(50)
E136
Window - Ntile
Free
145ms(100)
145ms(100)
109ms(100)
50ms(100)
E137
Window - FirstValue/LastValue
Free
1329ms(50)
350ms(50)
84ms(50)
66ms(50)
E138
Window - Frame (Sliding)
Free
513ms(50)
433ms(50)
55ms(50)
78ms(50)
E139
DistinctRedb - Find Duplicates
Pro
—
80ms(100)
—
48ms(100)
E140
DistinctByRedb - By Field
Pro
—
68ms(100)
—
30ms(100)
E141
WhereInRedb - Base Field
Free
98ms(5)
30ms(5)
44ms(5)
22ms(5)
E142
GroupByArray - Array Elements
Free
148ms(2)
173ms(2)
66ms(2)
70ms(2)
E143
SumRedbAsync - Base Field Sum
Free
7ms(5603)
7ms(5086)
9ms(13769)
11ms(13977)
E144
Min/MaxRedbAsync - Date Range
Free
7ms(2)
8ms(2)
7ms(2)
19ms(2)
E145
AverageRedbAsync - Base Field Avg
Free
13ms(1)
12ms(1)
12ms(1)
22ms(1)
E146
AggregateRedbAsync - Batch Base
Free
6ms(5603)
7ms(5086)
10ms(13769)
11ms(13977)
E147
Window - PartitionByRedb
Free
38ms(50)
54ms(50)
46ms(50)
40ms(50)
E148
Window - OrderByRedb
Free
25ms(50)
53ms(50)
4ms(50)
38ms(50)
E149
Select - Projection
Free
1486ms(100)
130ms(100)
563ms(100)
56ms(100)
E150
Array Aggregation
Free
104ms(5588)
103ms(4900)
91ms(13400)
68ms(13600)
E151
Where - Arithmetic Multiply
Pro
—
150ms(2008)
—
84ms(5573)
E152
Where - Arithmetic Add Fields
Pro
—
195ms(3185)
—
110ms(8842)
E153
Where - String ToLower
Pro
—
151ms(4948)
—
98ms(13731)
E154
Where - String Trim
Pro
—
132ms(4948)
—
84ms(13733)
E155
Where - String Chain
Pro
—
133ms(3968)
—
111ms(11013)
E156
Where - Math.Abs
Pro
—
115ms(1225)
—
87ms(3402)
E157
WhereRedb - DateTime.Year
Pro
—
70ms(5086)
—
39ms(13977)
E158
Where - Parentheses Priority
Pro
—
125ms(2008)
—
90ms(5573)
E159
Where - Nested Math
Pro
—
134ms(2498)
—
82ms(6931)
E160
TreeQuery - Expressions
Pro
—
85ms(60)
—
27ms(60)
E161
Sql.Function - COALESCE
Pro
—
124ms(4165)
—
102ms(11562)
E162
Sql.Function - POWER
Pro
—
117ms(4165)
—
80ms(11562)
E163
Sql.Function - Nested
Pro
—
123ms(4703)
—
98ms(13053)
E164
Base Fields - Single Object
Free
32ms(1)
40ms(1)
67ms(1)
66ms(1)
E165
Base Fields - Batch Operations
Free
37ms(10)
34ms(10)
54ms(10)
60ms(10)
E166
Generic with Props=null
Free
38ms(1)
44ms(1)
56ms(1)
59ms(1)
E167
Mixed Batch - Generic and Non-Generic
Free
43ms(4)
40ms(4)
61ms(4)
57ms(4)
E168
Array - Contains
Free
1566ms(1133)
213ms(1028)
696ms(2809)
124ms(2851)
E169
Array - Contains OR
Free
1415ms(1673)
261ms(1518)
747ms(4149)
139ms(4211)
E170
Array - Contains AND
Free
1334ms(1133)
258ms(1028)
771ms(2809)
115ms(2851)
E171
Scalar + Array Combined
Free
1459ms(810)
232ms(735)
762ms(2010)
138ms(2040)
E172
String.Length Filter
Free
1365ms(4913)
122ms(4458)
611ms(12191)
85ms(12373)
E173
TreeQuery - GroupBy
Free
125ms(1)
40ms(1)
73ms(1)
22ms(1)
E174
TreeQuery - Window Functions
Free
45ms(20)
52ms(100)
34ms(20)
24ms(100)
E175
TreeQuery - GroupBy + Window
Pro
—
43ms(1)
—
22ms(1)
E176
TreeQuery - DistinctBy
Pro
—
56ms(1)
—
24ms(1)
E177
TreeQuery - DistinctByRedb
Pro
—
29ms(20)
—
18ms(20)
E178
TreeQuery - OrderBy
Free
130ms(100)
54ms(100)
60ms(100)
24ms(100)
E179
TreeQuery - OrderByDescending
Free
126ms(100)
71ms(100)
82ms(100)
22ms(100)
E180
TreeQuery - DistinctBy + OrderBy
Pro
—
45ms(1)
—
25ms(1)
E181
Delete - Single Object
Free
143ms(1)
155ms(1)
158ms(1)
198ms(1)
E182
Delete - Batch
Free
306ms(5)
288ms(5)
530ms(5)
537ms(5)
E183
FirstOrDefaultAsync
Free
83ms(1)
79ms(1)
91ms(1)
65ms(1)
E184
Where - Nullable Field
Free
113ms(5453)
137ms(4948)
129ms(13772)
123ms(13731)
E185
Where - Combined Conditions
Free
122ms(4913)
167ms(4458)
183ms(12193)
109ms(12375)
E186
Object Reference - Load
Free
157ms(1)
206ms(1)
223ms(1)
265ms(1)
E187
Update - Existing Object
Free
143ms(1)
106ms(1)
133ms(1)
130ms(1)
E190
SumAsync - With Filter
Free
38ms(1)
122ms(1)
38ms(1)
71ms(1)
E191
Window - With Filter
Free
464ms(20)
341ms(20)
132ms(20)
58ms(20)
E192
AggregateAsync - With Filter
Free
46ms(1)
87ms(1)
54ms(1)
25ms(1)
E193
AverageAsync - With Filter
Free
38ms(1)
113ms(1)
84ms(1)
67ms(1)
E194
MinMaxAsync - With Filter
Free
79ms(1)
260ms(1)
92ms(1)
135ms(1)
E195
GroupBy + Window - With Filter
Pro
—
64ms(5)
—
42ms(5)

Summary

mssql
121 OK
mssql.pro
141 OK
postgres
122 OK
postgres.pro
141 OK