Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

refactor: Restructure aggregate query syntax #373

Merged

Conversation

AndrewSisley
Copy link
Contributor

Closes #365

Restructures aggregate query syntax in preparation for top-level queries, and aggregate filters as discussed on discord.

image

@AndrewSisley AndrewSisley added area/query Related to the query component refactor This issue specific to or requires *notable* refactoring of existing codebases and components labels Apr 21, 2022
@AndrewSisley AndrewSisley added this to the DefraDB v0.3 milestone Apr 21, 2022
@AndrewSisley AndrewSisley self-assigned this Apr 21, 2022
@codecov
Copy link

codecov bot commented Apr 21, 2022

Codecov Report

Merging #373 (3ad3810) into develop (1b78e79) will increase coverage by 0.14%.
The diff coverage is 83.24%.

Impacted file tree graph

@@             Coverage Diff             @@
##           develop     #373      +/-   ##
===========================================
+ Coverage    65.11%   65.26%   +0.14%     
===========================================
  Files           80       80              
  Lines         9240     9251      +11     
===========================================
+ Hits          6017     6038      +21     
+ Misses        2607     2595      -12     
- Partials       616      618       +2     
Impacted Files Coverage Δ
query/graphql/planner/sum.go 77.41% <75.00%> (+1.95%) ⬆️
query/graphql/schema/generate.go 80.72% <84.82%> (+0.08%) ⬆️
query/graphql/parser/query.go 75.20% <100.00%> (+1.52%) ⬆️
query/graphql/planner/count.go 93.75% <100.00%> (+6.90%) ⬆️
query/graphql/planner/select.go 72.98% <100.00%> (+0.66%) ⬆️

@source-devs

This comment was marked as spam.

@AndrewSisley AndrewSisley force-pushed the sisley/refactor/I364-aggregate-query-restructure branch from 8489d17 to 47ad426 Compare April 21, 2022 20:20
@source-devs

This comment was marked as spam.

Copy link
Member

@shahzadlone shahzadlone left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Great stuff!

db/tests/query/complex/utils.go Show resolved Hide resolved
db/tests/query/complex/with_sum_test.go Show resolved Hide resolved
query/graphql/parser/query.go Outdated Show resolved Hide resolved
for _, t := range g.typeDefs {
sumArg := g.genSumBaseArgInputs(t)
sumBaseArgs[sumArg.Name()] = sumArg
// This needs to happen for all types before calling genSumFieldConfig
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

By 'this' do you mean the previous chunk of code or the code that follows up until g.genSumFieldConfig(t, sumBaseArgs) ?

Perhaps a line break before (if referring the code that follows) the comment line.

OR a line break after (if referring to the previous chunk of code above) the comment line.

To help make it more obvious?

Copy link
Contributor Author

@AndrewSisley AndrewSisley Apr 22, 2022

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Hmmm thought it was common understanding that comments always apply to the code below them, but I will make it clearer

  • Make comment clearer

query/graphql/schema/generate.go Show resolved Hide resolved
query/graphql/schema/generate.go Show resolved Hide resolved
query/graphql/schema/generate.go Outdated Show resolved Hide resolved
query/graphql/schema/generate.go Outdated Show resolved Hide resolved
@AndrewSisley AndrewSisley force-pushed the sisley/refactor/I364-aggregate-query-restructure branch from 47ad426 to fd19c0e Compare April 22, 2022 14:48
@source-devs
Copy link

Benchmark Results

Summary

  • 113 Benchmarks successfully compared.
  • 65 Benchmarks were ✅ Better.
  • 48 Benchmarks were ❌ Worse .
  • 0 Benchmarks were ✨ Unchanged.
✅ See Better Results...
time/opdelta
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%285ms ± 0%−3.83%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%47.9ms ± 0%−0.06%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%460ms ± 0%−2.52%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.76s ± 0%−3.53%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%358µs ± 0%−6.22%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%4.04ms ± 0%−3.18%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.0ms ± 0%−5.83%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%394µs ± 0%−0.44%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%3.98ms ± 0%−3.03%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%263µs ± 0%−14.57%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%1.90ms ± 0%−1.82%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%24.1ms ± 0%−3.33%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%1.94ms ± 0%−0.28%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.38ms ± 0%−4.37%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%9.6ms ± 0%−5.72%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%485µs ± 0%−15.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.44ms ± 0%−8.07%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%438µs ± 0%−15.18%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%725µs ± 0%−7.43%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%304µs ± 0%−9.50%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%316µs ± 0%−8.65%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%272µs ± 0%−3.74%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%441µs ± 0%−6.11%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.50ms ± 0%−4.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%17.5µs ± 0%−0.58%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%18.3µs ± 0%−1.18%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%148µs ± 0%−6.25%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%146µs ± 0%−11.55%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%157µs ± 0%−7.04%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%194µs ± 0%−13.43%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%16.5µs ± 0%−4.74%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%20.4µs ± 0%−5.13%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%26.3µs ± 0%−12.90%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%160µs ± 0%−3.13%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%168µs ± 0%−3.51%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%169µs ± 0%−6.36%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%182µs ± 0%−4.57%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%225µs ± 0%−0.40%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%59.1µs ± 0%−1.00%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%390µs ± 0%−6.15%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%551µs ± 0%−2.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%45.6µs ± 0%−8.57%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%428µs ± 0%−7.14%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%584µs ± 0%−1.32%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%127µs ± 0%−8.78%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%139µs ± 0%−0.06%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%140µs ± 0%−4.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%150µs ± 0%−6.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.24ms ± 0%−3.68%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.23ms ± 0%−11.70%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.34ms ± 0%−2.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%124µs ± 0%−8.29%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%131µs ± 0%−0.03%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.32ms ± 0%−0.36%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.24ms ± 0%−13.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%9.7µs ± 0%−34.30%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%10.4µs ± 0%−13.36%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%11.3µs ± 0%−31.06%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%18.2µs ± 0%−4.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%101µs ± 0%−11.52%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%108µs ± 0%−4.76%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%116µs ± 0%−0.82%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%136µs ± 0%−4.99%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%139µs ± 0%−1.10%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.35ms ± 0%−3.51%(p=1.000 n=1+1)
 
❌ See Worse Results...
time/opdelta
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%14.0ms ± 0%+17.22%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%128ms ± 0%+12.05%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%1.25s ± 0%+14.02%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%265µs ± 0%+0.35%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%10.4ms ± 0%+1.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%530µs ± 0%+5.73%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%449µs ± 0%+2.08%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%735µs ± 0%+5.03%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%651µs ± 0%+1.49%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%13.1ms ± 0%+5.44%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%16.5µs ± 0%+0.57%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%23.5µs ± 0%+6.84%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%175µs ± 0%+0.95%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%17.6µs ± 0%+1.17%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%18.7µs ± 0%+0.19%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%57.5µs ± 0%+6.77%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%56.7µs ± 0%+5.33%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%66.0µs ± 0%+9.34%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%75.2µs ± 0%+6.77%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%436µs ± 0%+13.02%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%458µs ± 0%+13.88%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%450µs ± 0%+2.49%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%57.1µs ± 0%+12.32%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%56.9µs ± 0%+2.17%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%63.9µs ± 0%+2.20%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%81.4µs ± 0%+7.81%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%457µs ± 0%+17.89%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%483µs ± 0%+19.71%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%549µs ± 0%+4.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%145µs ± 0%+5.16%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.38ms ± 0%+6.94%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.58ms ± 0%+1.05%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%135µs ± 0%+4.09%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%139µs ± 0%+3.74%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%153µs ± 0%+5.47%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.33ms ± 0%+7.27%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.51ms ± 0%+3.84%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.69ms ± 0%+3.80%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%11.1µs ± 0%+3.69%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%135µs ± 0%+1.74%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%183µs ± 0%+1.01%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%138µs ± 0%+5.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%138µs ± 0%+4.67%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%140µs ± 0%+3.52%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.31ms ± 0%+2.80%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.28ms ± 0%+0.99%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.40ms ± 0%+12.20%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.49ms ± 0%+12.10%(p=1.000 n=1+1)
 
✨ See Unchanged Results...
time/opdelta
 
🐋 See Full Results...
develop.txtcurrent.txt
time/opdelta
pkg:github.com/sourcenetwork/defradb/bench/collection goos:linux goarch:amd64
_Collection_UserSimple_CreateMany_Sync_0_10-411.4ms ± 0%11.4ms ± 0%−0.14%(p=1.000 n=1+1)
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%285ms ± 0%−3.83%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%14.0ms ± 0%+17.22%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%128ms ± 0%+12.05%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%1.25s ± 0%+14.02%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%47.9ms ± 0%−0.06%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%460ms ± 0%−2.52%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.76s ± 0%−3.53%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%358µs ± 0%−6.22%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%4.04ms ± 0%−3.18%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.0ms ± 0%−5.83%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%394µs ± 0%−0.44%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%3.98ms ± 0%−3.03%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%263µs ± 0%−14.57%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%1.90ms ± 0%−1.82%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%24.1ms ± 0%−3.33%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%265µs ± 0%+0.35%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%1.94ms ± 0%−0.28%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/query/simple goos:linux goarch:amd64
_Query_UserSimple_Query_Sync_10-4461µs ± 0%373µs ± 0%−19.01%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.38ms ± 0%−4.37%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%9.6ms ± 0%−5.72%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%485µs ± 0%−15.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.44ms ± 0%−8.07%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%10.4ms ± 0%+1.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%438µs ± 0%−15.18%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%530µs ± 0%+5.73%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%449µs ± 0%+2.08%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%725µs ± 0%−7.43%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%735µs ± 0%+5.03%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%651µs ± 0%+1.49%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%304µs ± 0%−9.50%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%316µs ± 0%−8.65%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%272µs ± 0%−3.74%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%441µs ± 0%−6.11%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.50ms ± 0%−4.64%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%13.1ms ± 0%+5.44%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/storage goos:linux goarch:amd64
_Storage_Simple_Read_Sync_1_10/ValueSize:0064-414.7µs ± 0%16.4µs ± 0%+11.32%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%16.5µs ± 0%+0.57%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%17.5µs ± 0%−0.58%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%18.3µs ± 0%−1.18%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%23.5µs ± 0%+6.84%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%148µs ± 0%−6.25%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%146µs ± 0%−11.55%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%157µs ± 0%−7.04%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%175µs ± 0%+0.95%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%194µs ± 0%−13.43%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%16.5µs ± 0%−4.74%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%17.6µs ± 0%+1.17%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%18.7µs ± 0%+0.19%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%20.4µs ± 0%−5.13%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%26.3µs ± 0%−12.90%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%160µs ± 0%−3.13%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%168µs ± 0%−3.51%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%169µs ± 0%−6.36%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%182µs ± 0%−4.57%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%225µs ± 0%−0.40%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%57.5µs ± 0%+6.77%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%56.7µs ± 0%+5.33%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%59.1µs ± 0%−1.00%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%66.0µs ± 0%+9.34%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%75.2µs ± 0%+6.77%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%436µs ± 0%+13.02%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%458µs ± 0%+13.88%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%390µs ± 0%−6.15%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%450µs ± 0%+2.49%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%551µs ± 0%−2.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%45.6µs ± 0%−8.57%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%57.1µs ± 0%+12.32%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%56.9µs ± 0%+2.17%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%63.9µs ± 0%+2.20%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%81.4µs ± 0%+7.81%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%457µs ± 0%+17.89%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%483µs ± 0%+19.71%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%428µs ± 0%−7.14%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%549µs ± 0%+4.63%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%584µs ± 0%−1.32%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%127µs ± 0%−8.78%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%145µs ± 0%+5.16%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%139µs ± 0%−0.06%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%140µs ± 0%−4.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%150µs ± 0%−6.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.24ms ± 0%−3.68%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.23ms ± 0%−11.70%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.38ms ± 0%+6.94%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.34ms ± 0%−2.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.58ms ± 0%+1.05%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%124µs ± 0%−8.29%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%131µs ± 0%−0.03%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%135µs ± 0%+4.09%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%139µs ± 0%+3.74%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%153µs ± 0%+5.47%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.33ms ± 0%+7.27%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.32ms ± 0%−0.36%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.24ms ± 0%−13.22%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.51ms ± 0%+3.84%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.69ms ± 0%+3.80%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%9.7µs ± 0%−34.30%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%10.4µs ± 0%−13.36%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%11.1µs ± 0%+3.69%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%11.3µs ± 0%−31.06%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%18.2µs ± 0%−4.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%101µs ± 0%−11.52%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%108µs ± 0%−4.76%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%116µs ± 0%−0.82%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%135µs ± 0%+1.74%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%183µs ± 0%+1.01%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%138µs ± 0%+5.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%138µs ± 0%+4.67%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%136µs ± 0%−4.99%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%139µs ± 0%−1.10%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%140µs ± 0%+3.52%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.31ms ± 0%+2.80%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.28ms ± 0%+0.99%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.35ms ± 0%−3.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.40ms ± 0%+12.20%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.49ms ± 0%+12.10%(p=1.000 n=1+1)
 

@source-devs
Copy link

Benchmark Results

Summary

  • 113 Benchmarks successfully compared.
  • 42 Benchmarks were ✅ Better.
  • 71 Benchmarks were ❌ Worse .
  • 0 Benchmarks were ✨ Unchanged.
✅ See Better Results...
time/opdelta
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%439ms ± 0%−7.04%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.60s ± 0%−6.73%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%359µs ± 0%−5.90%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%3.98ms ± 0%−4.64%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.8ms ± 0%−3.75%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%391µs ± 0%−1.18%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%23.3ms ± 0%−6.44%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%1.86ms ± 0%−4.57%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.37ms ± 0%−5.36%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.41ms ± 0%−9.40%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%512µs ± 0%−0.93%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%641µs ± 0%−0.17%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%317µs ± 0%−8.41%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%274µs ± 0%−3.07%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%464µs ± 0%−1.09%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%12.2ms ± 0%−1.60%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%16.9µs ± 0%−3.97%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%17.6µs ± 0%−4.57%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%140µs ± 0%−11.06%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%17.0µs ± 0%−2.24%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%18.6µs ± 0%−0.19%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%21.2µs ± 0%−1.02%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%28.1µs ± 0%−7.05%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%164µs ± 0%−0.70%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%156µs ± 0%−10.29%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%178µs ± 0%−1.60%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%185µs ± 0%−3.06%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%52.5µs ± 0%−2.44%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%408µs ± 0%−1.91%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%72.6µs ± 0%−3.79%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%433µs ± 0%−6.20%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%507µs ± 0%−3.44%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%553µs ± 0%−6.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%137µs ± 0%−1.17%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.33ms ± 0%−4.46%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.44ms ± 0%−7.69%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%121µs ± 0%−9.93%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%10.8µs ± 0%−26.40%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%10.3µs ± 0%−14.15%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%12.6µs ± 0%−23.18%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%18.2µs ± 0%−4.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%143µs ± 0%−0.57%(p=1.000 n=1+1)
 
❌ See Worse Results...
time/opdelta
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%319ms ± 0%+7.69%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%14.8ms ± 0%+23.62%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%133ms ± 0%+16.32%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%1.30s ± 0%+18.31%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%49.8ms ± 0%+3.92%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%5.02ms ± 0%+22.48%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%366µs ± 0%+18.63%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%2.04ms ± 0%+5.45%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%265µs ± 0%+0.59%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%10.3ms ± 0%+1.24%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%590µs ± 0%+3.44%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%10.7ms ± 0%+5.17%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%655µs ± 0%+30.68%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%563µs ± 0%+28.07%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%1033µs ± 0%+31.96%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%836µs ± 0%+19.49%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%339µs ± 0%+0.83%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.74ms ± 0%+10.54%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%17.5µs ± 0%+6.51%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%23.0µs ± 0%+4.40%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%165µs ± 0%+0.15%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%173µs ± 0%+2.75%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%192µs ± 0%+10.67%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%265µs ± 0%+18.29%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%20.5µs ± 0%+18.24%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%234µs ± 0%+3.35%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%57.1µs ± 0%+5.92%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%62.1µs ± 0%+4.12%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%77.7µs ± 0%+28.61%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%77.9µs ± 0%+10.58%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%433µs ± 0%+12.32%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%453µs ± 0%+12.64%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%508µs ± 0%+15.73%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%688µs ± 0%+21.15%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%67.8µs ± 0%+35.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%58.8µs ± 0%+15.60%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%62.1µs ± 0%+11.48%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%75.8µs ± 0%+21.35%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%449µs ± 0%+15.59%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%460µs ± 0%+13.87%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%145µs ± 0%+4.18%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%142µs ± 0%+2.26%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%149µs ± 0%+2.01%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%179µs ± 0%+11.65%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.45ms ± 0%+12.46%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.45ms ± 0%+12.07%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.48ms ± 0%+8.14%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%137µs ± 0%+4.76%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%135µs ± 0%+4.60%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%174µs ± 0%+29.73%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%191µs ± 0%+31.51%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.41ms ± 0%+13.53%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.50ms ± 0%+13.62%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.55ms ± 0%+8.18%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.54ms ± 0%+5.99%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.88ms ± 0%+15.77%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%15.2µs ± 0%+42.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%118µs ± 0%+3.18%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%123µs ± 0%+8.75%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%134µs ± 0%+14.17%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%142µs ± 0%+7.03%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%194µs ± 0%+6.76%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%151µs ± 0%+15.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%140µs ± 0%+6.10%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%150µs ± 0%+6.17%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%151µs ± 0%+11.24%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.52ms ± 0%+20.11%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.44ms ± 0%+13.49%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.57ms ± 0%+12.01%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.57ms ± 0%+26.01%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.49ms ± 0%+12.27%(p=1.000 n=1+1)
 
✨ See Unchanged Results...
time/opdelta
 
🐋 See Full Results...
develop.txtcurrent.txt
time/opdelta
pkg:github.com/sourcenetwork/defradb/bench/collection goos:linux goarch:amd64
_Collection_UserSimple_CreateMany_Sync_0_10-411.4ms ± 0%11.7ms ± 0%+1.88%(p=1.000 n=1+1)
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%319ms ± 0%+7.69%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%14.8ms ± 0%+23.62%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%133ms ± 0%+16.32%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%1.30s ± 0%+18.31%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%49.8ms ± 0%+3.92%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%439ms ± 0%−7.04%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.60s ± 0%−6.73%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%359µs ± 0%−5.90%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%3.98ms ± 0%−4.64%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.8ms ± 0%−3.75%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%391µs ± 0%−1.18%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%5.02ms ± 0%+22.48%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%366µs ± 0%+18.63%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%2.04ms ± 0%+5.45%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%23.3ms ± 0%−6.44%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%265µs ± 0%+0.59%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%1.86ms ± 0%−4.57%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/query/simple goos:linux goarch:amd64
_Query_UserSimple_Query_Sync_10-4461µs ± 0%393µs ± 0%−14.80%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.37ms ± 0%−5.36%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%10.3ms ± 0%+1.24%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%590µs ± 0%+3.44%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.41ms ± 0%−9.40%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%10.7ms ± 0%+5.17%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%512µs ± 0%−0.93%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%655µs ± 0%+30.68%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%563µs ± 0%+28.07%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%1033µs ± 0%+31.96%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%836µs ± 0%+19.49%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%641µs ± 0%−0.17%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%339µs ± 0%+0.83%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%317µs ± 0%−8.41%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%274µs ± 0%−3.07%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%464µs ± 0%−1.09%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.74ms ± 0%+10.54%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%12.2ms ± 0%−1.60%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/storage goos:linux goarch:amd64
_Storage_Simple_Read_Sync_1_10/ValueSize:0064-414.7µs ± 0%16.6µs ± 0%+12.94%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%17.5µs ± 0%+6.51%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%16.9µs ± 0%−3.97%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%17.6µs ± 0%−4.57%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%23.0µs ± 0%+4.40%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%140µs ± 0%−11.06%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%165µs ± 0%+0.15%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%173µs ± 0%+2.75%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%192µs ± 0%+10.67%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%265µs ± 0%+18.29%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%20.5µs ± 0%+18.24%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%17.0µs ± 0%−2.24%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%18.6µs ± 0%−0.19%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%21.2µs ± 0%−1.02%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%28.1µs ± 0%−7.05%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%164µs ± 0%−0.70%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%156µs ± 0%−10.29%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%178µs ± 0%−1.60%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%185µs ± 0%−3.06%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%234µs ± 0%+3.35%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%57.1µs ± 0%+5.92%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%52.5µs ± 0%−2.44%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%62.1µs ± 0%+4.12%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%77.7µs ± 0%+28.61%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%77.9µs ± 0%+10.58%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%433µs ± 0%+12.32%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%453µs ± 0%+12.64%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%408µs ± 0%−1.91%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%508µs ± 0%+15.73%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%688µs ± 0%+21.15%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%67.8µs ± 0%+35.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%58.8µs ± 0%+15.60%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%62.1µs ± 0%+11.48%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%75.8µs ± 0%+21.35%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%72.6µs ± 0%−3.79%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%449µs ± 0%+15.59%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%460µs ± 0%+13.87%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%433µs ± 0%−6.20%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%507µs ± 0%−3.44%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%553µs ± 0%−6.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%145µs ± 0%+4.18%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%137µs ± 0%−1.17%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%142µs ± 0%+2.26%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%149µs ± 0%+2.01%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%179µs ± 0%+11.65%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.45ms ± 0%+12.46%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.33ms ± 0%−4.46%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.45ms ± 0%+12.07%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.48ms ± 0%+8.14%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.44ms ± 0%−7.69%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%121µs ± 0%−9.93%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%137µs ± 0%+4.76%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%135µs ± 0%+4.60%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%174µs ± 0%+29.73%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%191µs ± 0%+31.51%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.41ms ± 0%+13.53%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.50ms ± 0%+13.62%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.55ms ± 0%+8.18%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.54ms ± 0%+5.99%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.88ms ± 0%+15.77%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%10.8µs ± 0%−26.40%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%10.3µs ± 0%−14.15%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%15.2µs ± 0%+42.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%12.6µs ± 0%−23.18%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%18.2µs ± 0%−4.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%118µs ± 0%+3.18%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%123µs ± 0%+8.75%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%134µs ± 0%+14.17%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%142µs ± 0%+7.03%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%194µs ± 0%+6.76%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%151µs ± 0%+15.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%140µs ± 0%+6.10%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%143µs ± 0%−0.57%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%150µs ± 0%+6.17%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%151µs ± 0%+11.24%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.52ms ± 0%+20.11%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.44ms ± 0%+13.49%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.57ms ± 0%+12.01%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.57ms ± 0%+26.01%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.49ms ± 0%+12.27%(p=1.000 n=1+1)
 

@AndrewSisley AndrewSisley force-pushed the sisley/refactor/I364-aggregate-query-restructure branch from 4878f65 to c818ee1 Compare April 25, 2022 14:40
@source-devs
Copy link

Benchmark Results

Summary

  • 113 Benchmarks successfully compared.
  • 109 Benchmarks were ✅ Better.
  • 4 Benchmarks were ❌ Worse .
  • 0 Benchmarks were ✨ Unchanged.
✅ See Better Results...
time/opdelta
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%216ms ± 0%−27.22%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%9.6ms ± 0%−19.73%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%97ms ± 0%−15.51%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%0.98s ± 0%−10.53%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%43.7ms ± 0%−8.84%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%424ms ± 0%−10.07%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.46s ± 0%−9.74%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%318µs ± 0%−16.73%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%3.38ms ± 0%−19.01%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.4ms ± 0%−4.80%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%391µs ± 0%−1.17%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%3.91ms ± 0%−4.77%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%308µs ± 0%−0.21%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.12ms ± 0%−22.06%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%9.0ms ± 0%−11.74%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%408µs ± 0%−28.43%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.25ms ± 0%−20.12%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%9.6ms ± 0%−6.01%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%374µs ± 0%−27.60%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%421µs ± 0%−15.94%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%422µs ± 0%−3.94%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%635µs ± 0%−18.87%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%619µs ± 0%−11.52%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%610µs ± 0%−4.93%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%267µs ± 0%−20.42%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%268µs ± 0%−22.54%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%271µs ± 0%−4.22%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%394µs ± 0%−16.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.32ms ± 0%−16.25%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%11.9ms ± 0%−3.93%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%12.9µs ± 0%−21.48%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%13.9µs ± 0%−20.83%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%15.1µs ± 0%−18.22%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%18.8µs ± 0%−14.77%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%121µs ± 0%−23.28%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%128µs ± 0%−22.19%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%141µs ± 0%−16.40%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%154µs ± 0%−11.09%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%185µs ± 0%−17.56%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%14.8µs ± 0%−14.38%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%14.7µs ± 0%−15.45%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%15.0µs ± 0%−19.59%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%16.1µs ± 0%−24.83%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%20.4µs ± 0%−32.40%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%135µs ± 0%−18.32%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%138µs ± 0%−20.66%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%148µs ± 0%−18.18%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%156µs ± 0%−18.28%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%195µs ± 0%−14.06%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%42.4µs ± 0%−21.27%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%43.7µs ± 0%−18.87%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%45.5µs ± 0%−23.80%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%51.5µs ± 0%−14.69%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%63.0µs ± 0%−10.51%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%337µs ± 0%−12.51%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%339µs ± 0%−15.61%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%354µs ± 0%−14.80%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%386µs ± 0%−12.14%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%477µs ± 0%−15.98%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%43.2µs ± 0%−13.34%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%42.8µs ± 0%−15.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%45.5µs ± 0%−18.32%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%50.4µs ± 0%−19.36%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%66.7µs ± 0%−11.65%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%335µs ± 0%−13.58%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%332µs ± 0%−17.76%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%358µs ± 0%−22.28%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%386µs ± 0%−26.53%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%479µs ± 0%−19.16%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%115µs ± 0%−17.36%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%118µs ± 0%−14.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%119µs ± 0%−14.30%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%124µs ± 0%−15.43%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%136µs ± 0%−14.91%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.16ms ± 0%−9.64%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.19ms ± 0%−14.49%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.19ms ± 0%−8.17%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.23ms ± 0%−10.34%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.36ms ± 0%−12.97%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%110µs ± 0%−18.19%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%113µs ± 0%−13.79%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%116µs ± 0%−10.82%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%119µs ± 0%−11.26%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%130µs ± 0%−10.50%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.11ms ± 0%−10.51%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.14ms ± 0%−14.00%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.13ms ± 0%−21.15%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.18ms ± 0%−18.65%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.32ms ± 0%−19.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%8.0µs ± 0%−45.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%8.4µs ± 0%−29.98%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%9.1µs ± 0%−15.39%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%10.8µs ± 0%−34.10%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%14.2µs ± 0%−25.73%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%84µs ± 0%−26.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%89µs ± 0%−21.12%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%98µs ± 0%−16.68%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%109µs ± 0%−17.54%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%146µs ± 0%−19.50%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%118µs ± 0%−9.23%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%120µs ± 0%−8.78%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%116µs ± 0%−19.27%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%120µs ± 0%−15.20%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%125µs ± 0%−7.50%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.14ms ± 0%−10.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.22ms ± 0%−4.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.21ms ± 0%−14.04%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.21ms ± 0%−2.80%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.27ms ± 0%−4.58%(p=1.000 n=1+1)
 
❌ See Worse Results...
time/opdelta
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%2.32ms ± 0%+20.03%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%25.6ms ± 0%+2.70%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%309µs ± 0%+17.30%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%2.17ms ± 0%+11.37%(p=1.000 n=1+1)
 
✨ See Unchanged Results...
time/opdelta
 
🐋 See Full Results...
develop.txtcurrent.txt
time/opdelta
pkg:github.com/sourcenetwork/defradb/bench/collection goos:linux goarch:amd64
_Collection_UserSimple_CreateMany_Sync_0_10-411.4ms ± 0%10.7ms ± 0%−6.68%(p=1.000 n=1+1)
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%216ms ± 0%−27.22%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%9.6ms ± 0%−19.73%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%97ms ± 0%−15.51%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%0.98s ± 0%−10.53%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%43.7ms ± 0%−8.84%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%424ms ± 0%−10.07%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.46s ± 0%−9.74%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%318µs ± 0%−16.73%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%3.38ms ± 0%−19.01%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.4ms ± 0%−4.80%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%391µs ± 0%−1.17%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%3.91ms ± 0%−4.77%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%308µs ± 0%−0.21%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%2.32ms ± 0%+20.03%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%25.6ms ± 0%+2.70%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%309µs ± 0%+17.30%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%2.17ms ± 0%+11.37%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/query/simple goos:linux goarch:amd64
_Query_UserSimple_Query_Sync_10-4461µs ± 0%337µs ± 0%−26.82%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.12ms ± 0%−22.06%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%9.0ms ± 0%−11.74%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%408µs ± 0%−28.43%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.25ms ± 0%−20.12%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%9.6ms ± 0%−6.01%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%374µs ± 0%−27.60%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%421µs ± 0%−15.94%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%422µs ± 0%−3.94%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%635µs ± 0%−18.87%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%619µs ± 0%−11.52%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%610µs ± 0%−4.93%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%267µs ± 0%−20.42%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%268µs ± 0%−22.54%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%271µs ± 0%−4.22%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%394µs ± 0%−16.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.32ms ± 0%−16.25%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%11.9ms ± 0%−3.93%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/storage goos:linux goarch:amd64
_Storage_Simple_Read_Sync_1_10/ValueSize:0064-414.7µs ± 0%12.4µs ± 0%−15.56%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%12.9µs ± 0%−21.48%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%13.9µs ± 0%−20.83%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%15.1µs ± 0%−18.22%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%18.8µs ± 0%−14.77%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%121µs ± 0%−23.28%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%128µs ± 0%−22.19%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%141µs ± 0%−16.40%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%154µs ± 0%−11.09%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%185µs ± 0%−17.56%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%14.8µs ± 0%−14.38%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%14.7µs ± 0%−15.45%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%15.0µs ± 0%−19.59%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%16.1µs ± 0%−24.83%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%20.4µs ± 0%−32.40%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%135µs ± 0%−18.32%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%138µs ± 0%−20.66%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%148µs ± 0%−18.18%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%156µs ± 0%−18.28%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%195µs ± 0%−14.06%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%42.4µs ± 0%−21.27%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%43.7µs ± 0%−18.87%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%45.5µs ± 0%−23.80%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%51.5µs ± 0%−14.69%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%63.0µs ± 0%−10.51%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%337µs ± 0%−12.51%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%339µs ± 0%−15.61%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%354µs ± 0%−14.80%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%386µs ± 0%−12.14%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%477µs ± 0%−15.98%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%43.2µs ± 0%−13.34%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%42.8µs ± 0%−15.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%45.5µs ± 0%−18.32%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%50.4µs ± 0%−19.36%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%66.7µs ± 0%−11.65%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%335µs ± 0%−13.58%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%332µs ± 0%−17.76%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%358µs ± 0%−22.28%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%386µs ± 0%−26.53%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%479µs ± 0%−19.16%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%115µs ± 0%−17.36%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%118µs ± 0%−14.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%119µs ± 0%−14.30%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%124µs ± 0%−15.43%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%136µs ± 0%−14.91%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.16ms ± 0%−9.64%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.19ms ± 0%−14.49%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.19ms ± 0%−8.17%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.23ms ± 0%−10.34%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.36ms ± 0%−12.97%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%110µs ± 0%−18.19%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%113µs ± 0%−13.79%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%116µs ± 0%−10.82%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%119µs ± 0%−11.26%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%130µs ± 0%−10.50%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.11ms ± 0%−10.51%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.14ms ± 0%−14.00%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.13ms ± 0%−21.15%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.18ms ± 0%−18.65%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.32ms ± 0%−19.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%8.0µs ± 0%−45.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%8.4µs ± 0%−29.98%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%9.1µs ± 0%−15.39%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%10.8µs ± 0%−34.10%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%14.2µs ± 0%−25.73%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%84µs ± 0%−26.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%89µs ± 0%−21.12%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%98µs ± 0%−16.68%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%109µs ± 0%−17.54%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%146µs ± 0%−19.50%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%118µs ± 0%−9.23%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%120µs ± 0%−8.78%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%116µs ± 0%−19.27%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%120µs ± 0%−15.20%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%125µs ± 0%−7.50%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.14ms ± 0%−10.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.22ms ± 0%−4.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.21ms ± 0%−14.04%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.21ms ± 0%−2.80%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.27ms ± 0%−4.58%(p=1.000 n=1+1)
 

@jsimnz
Copy link
Member

jsimnz commented Apr 26, 2022

image

the type names on the Aggregate types are a concatenation of type, field, "AggregateInputObj", which as you can see in the image results in something like userpointsSumInputArg.

But the rest of the types follow a normal camel case, here we have "user" and "points" both lowercase, should prob be "userPointsSumInputArg".

Minor but it bugged me :p

Copy link
Member

@jsimnz jsimnz left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Nothing major, just a few notes.

In general, im not the biggest fan of the field symbol used for the input args to the sum stuff, but its mostly a function of how the gql spec works, so not much we can do about it atm.

Fields: gql.InputObjectConfigFieldMap{
"_": &gql.InputObjectFieldConfig{
Type: gql.Int,
Description: "Placeholder - empty object not permitted, but will have fields shortly",
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Is this a todo placeholder that should be resolved in this PR, or by "shortly" are you referring to later?

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

We could have it so theres no input arguments to _count until theres an actual need to define something here.

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

The first will likely be filter, but I'd also want limit and offset available here too at least. _count still needs input, otherwise there is no way to tell which child you want to count :)

query/graphql/schema/generate.go Show resolved Hide resolved
return nil, nil
}

fieldsEnum := gql.NewEnum(fieldsEnumCfg)
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Isn't there already a defined type to handle fieldsEnum?

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Ahh, there is, but it includes other fields like _key, _group, etc. Youre just constructing a "simple" type fields enum. Can prob do it outside of this func, in its own generator, and call it when we make the original type fields enum, so if they need to be reused its more readily available

Copy link
Contributor Author

@AndrewSisley AndrewSisley Apr 26, 2022

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Yeah is specific to here (or at least aggregate). Would like to organise these better and maybe rename them when we get round to refactoring generator, or maybe even when implementing average (which should share types with sum I think)

@AndrewSisley
Copy link
Contributor Author

But the rest of the types follow a normal camel case, here we have "user" and "points" both lowercase, should prob be "userPointsSumInputArg".

Really good spot - will have a look at that now (even if they get renamed when looking at average) as if it leaks into the release it looks really sloppy

In preparation for top-level queries, and aggregate filters
Should be a fair bit safer now and easier to read
@AndrewSisley AndrewSisley force-pushed the sisley/refactor/I364-aggregate-query-restructure branch from c818ee1 to 3ad3810 Compare April 26, 2022 15:22
@AndrewSisley
Copy link
Contributor Author

Really good spot - will have a look at that now (even if they get renamed when looking at average) as if it leaks into the release it looks really sloppy

Sorted, will merge after the build

@source-devs
Copy link

Benchmark Results

Summary

  • 113 Benchmarks successfully compared.
  • 105 Benchmarks were ✅ Better.
  • 8 Benchmarks were ❌ Worse .
  • 0 Benchmarks were ✨ Unchanged.
✅ See Better Results...
time/opdelta
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%218ms ± 0%−26.60%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%10.1ms ± 0%−15.94%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%100ms ± 0%−12.40%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%46.6ms ± 0%−2.75%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%451ms ± 0%−4.48%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.67s ± 0%−5.46%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%357µs ± 0%−6.46%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%3.54ms ± 0%−15.33%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.5ms ± 0%−4.60%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%357µs ± 0%−9.85%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%3.85ms ± 0%−6.05%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%258µs ± 0%−16.31%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%1.79ms ± 0%−7.54%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%24.2ms ± 0%−2.93%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%256µs ± 0%−2.95%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%1.88ms ± 0%−3.26%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.24ms ± 0%−14.37%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%9.3ms ± 0%−8.45%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%416µs ± 0%−27.18%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.24ms ± 0%−20.48%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%9.9ms ± 0%−2.74%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%397µs ± 0%−23.24%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%431µs ± 0%−13.99%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%435µs ± 0%−1.20%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%661µs ± 0%−15.54%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%659µs ± 0%−5.87%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%625µs ± 0%−2.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%288µs ± 0%−14.41%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%284µs ± 0%−18.06%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%277µs ± 0%−2.27%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%438µs ± 0%−6.80%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.43ms ± 0%−9.13%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%12.3ms ± 0%−0.50%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%13.4µs ± 0%−18.41%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%14.3µs ± 0%−18.73%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%15.9µs ± 0%−13.89%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%19.2µs ± 0%−12.71%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%124µs ± 0%−21.52%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%143µs ± 0%−13.39%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%141µs ± 0%−16.60%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%155µs ± 0%−10.66%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%191µs ± 0%−14.93%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%14.7µs ± 0%−15.37%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%15.9µs ± 0%−8.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%15.5µs ± 0%−16.54%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%17.7µs ± 0%−17.73%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%20.9µs ± 0%−30.87%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%142µs ± 0%−13.65%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%145µs ± 0%−16.87%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%154µs ± 0%−15.14%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%159µs ± 0%−16.97%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%202µs ± 0%−10.78%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%50.6µs ± 0%−6.06%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%48.6µs ± 0%−9.63%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%51.9µs ± 0%−12.99%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%59.3µs ± 0%−1.82%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%368µs ± 0%−8.53%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%378µs ± 0%−9.18%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%534µs ± 0%−5.90%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%49.3µs ± 0%−1.25%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%46.2µs ± 0%−9.15%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%52.3µs ± 0%−5.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%61.2µs ± 0%−2.04%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%66.7µs ± 0%−11.55%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%374µs ± 0%−3.70%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%366µs ± 0%−9.38%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%384µs ± 0%−16.83%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%447µs ± 0%−14.86%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%493µs ± 0%−16.69%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%122µs ± 0%−12.11%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%133µs ± 0%−4.05%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%136µs ± 0%−2.50%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%134µs ± 0%−8.42%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.26ms ± 0%−2.04%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.34ms ± 0%−3.77%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.22ms ± 0%−6.01%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.26ms ± 0%−8.32%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.40ms ± 0%−10.28%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%116µs ± 0%−14.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%122µs ± 0%−6.83%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%124µs ± 0%−4.14%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%123µs ± 0%−8.37%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%138µs ± 0%−4.61%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.18ms ± 0%−5.30%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.21ms ± 0%−8.91%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.24ms ± 0%−13.54%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.27ms ± 0%−12.46%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.34ms ± 0%−17.78%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%8.5µs ± 0%−42.35%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%9.1µs ± 0%−24.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%13.7µs ± 0%−16.32%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%16.5µs ± 0%−13.95%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%97µs ± 0%−15.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%102µs ± 0%−9.88%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%105µs ± 0%−10.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%132µs ± 0%−0.33%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%156µs ± 0%−14.03%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%122µs ± 0%−7.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%122µs ± 0%−15.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%125µs ± 0%−11.30%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%126µs ± 0%−7.23%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.20ms ± 0%−5.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.22ms ± 0%−4.44%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.21ms ± 0%−13.57%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.25ms ± 0%−5.49%(p=1.000 n=1+1)
 
❌ See Worse Results...
time/opdelta
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%1.12s ± 0%+1.86%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%71.8µs ± 0%+1.98%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%395µs ± 0%+2.31%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%463µs ± 0%+5.57%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%161µs ± 0%+0.77%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%12.1µs ± 0%+13.41%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%134µs ± 0%+2.70%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.28ms ± 0%+3.19%(p=1.000 n=1+1)
 
✨ See Unchanged Results...
time/opdelta
 
🐋 See Full Results...
develop.txtcurrent.txt
time/opdelta
pkg:github.com/sourcenetwork/defradb/bench/collection goos:linux goarch:amd64
_Collection_UserSimple_CreateMany_Sync_0_10-411.4ms ± 0%10.9ms ± 0%−5.15%(p=1.000 n=1+1)
_Collection_UserSimple_CreateMany_Sync_0_100-4297ms ± 0%218ms ± 0%−26.60%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-412.0ms ± 0%10.1ms ± 0%−15.94%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4114ms ± 0%100ms ± 0%−12.40%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.10s ± 0%1.12s ± 0%+1.86%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-447.9ms ± 0%46.6ms ± 0%−2.75%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4472ms ± 0%451ms ± 0%−4.48%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.94s ± 0%4.67s ± 0%−5.46%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4382µs ± 0%357µs ± 0%−6.46%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.18ms ± 0%3.54ms ± 0%−15.33%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-441.4ms ± 0%39.5ms ± 0%−4.60%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4396µs ± 0%357µs ± 0%−9.85%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.10ms ± 0%3.85ms ± 0%−6.05%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4308µs ± 0%258µs ± 0%−16.31%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-41.93ms ± 0%1.79ms ± 0%−7.54%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-424.9ms ± 0%24.2ms ± 0%−2.93%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4264µs ± 0%256µs ± 0%−2.95%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.95ms ± 0%1.88ms ± 0%−3.26%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/query/simple goos:linux goarch:amd64
_Query_UserSimple_Query_Sync_10-4461µs ± 0%352µs ± 0%−23.64%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.44ms ± 0%1.24ms ± 0%−14.37%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.2ms ± 0%9.3ms ± 0%−8.45%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4571µs ± 0%416µs ± 0%−27.18%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.56ms ± 0%1.24ms ± 0%−20.48%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.2ms ± 0%9.9ms ± 0%−2.74%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4517µs ± 0%397µs ± 0%−23.24%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4501µs ± 0%431µs ± 0%−13.99%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4440µs ± 0%435µs ± 0%−1.20%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4783µs ± 0%661µs ± 0%−15.54%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4700µs ± 0%659µs ± 0%−5.87%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4642µs ± 0%625µs ± 0%−2.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4336µs ± 0%288µs ± 0%−14.41%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4346µs ± 0%284µs ± 0%−18.06%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4283µs ± 0%277µs ± 0%−2.27%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4469µs ± 0%438µs ± 0%−6.80%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.43ms ± 0%−9.13%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-412.4ms ± 0%12.3ms ± 0%−0.50%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/storage goos:linux goarch:amd64
_Storage_Simple_Read_Sync_1_10/ValueSize:0064-414.7µs ± 0%12.4µs ± 0%−15.80%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-416.4µs ± 0%13.4µs ± 0%−18.41%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-417.6µs ± 0%14.3µs ± 0%−18.73%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-418.5µs ± 0%15.9µs ± 0%−13.89%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.0µs ± 0%19.2µs ± 0%−12.71%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4157µs ± 0%124µs ± 0%−21.52%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4165µs ± 0%143µs ± 0%−13.39%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4169µs ± 0%141µs ± 0%−16.60%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4173µs ± 0%155µs ± 0%−10.66%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4224µs ± 0%191µs ± 0%−14.93%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-417.3µs ± 0%14.7µs ± 0%−15.37%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-417.4µs ± 0%15.9µs ± 0%−8.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-418.6µs ± 0%15.5µs ± 0%−16.54%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-421.5µs ± 0%17.7µs ± 0%−17.73%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.2µs ± 0%20.9µs ± 0%−30.87%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4165µs ± 0%142µs ± 0%−13.65%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4174µs ± 0%145µs ± 0%−16.87%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4181µs ± 0%154µs ± 0%−15.14%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4191µs ± 0%159µs ± 0%−16.97%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4226µs ± 0%202µs ± 0%−10.78%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-453.9µs ± 0%50.6µs ± 0%−6.06%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-453.8µs ± 0%48.6µs ± 0%−9.63%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-459.7µs ± 0%51.9µs ± 0%−12.99%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-460.4µs ± 0%59.3µs ± 0%−1.82%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-470.4µs ± 0%71.8µs ± 0%+1.98%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4386µs ± 0%395µs ± 0%+2.31%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4402µs ± 0%368µs ± 0%−8.53%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4416µs ± 0%378µs ± 0%−9.18%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4439µs ± 0%463µs ± 0%+5.57%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4568µs ± 0%534µs ± 0%−5.90%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-449.9µs ± 0%49.3µs ± 0%−1.25%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-450.9µs ± 0%46.2µs ± 0%−9.15%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-455.7µs ± 0%52.3µs ± 0%−5.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-462.5µs ± 0%61.2µs ± 0%−2.04%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-475.5µs ± 0%66.7µs ± 0%−11.55%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4388µs ± 0%374µs ± 0%−3.70%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4404µs ± 0%366µs ± 0%−9.38%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4461µs ± 0%384µs ± 0%−16.83%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4525µs ± 0%447µs ± 0%−14.86%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4592µs ± 0%493µs ± 0%−16.69%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4139µs ± 0%122µs ± 0%−12.11%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4138µs ± 0%133µs ± 0%−4.05%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4139µs ± 0%136µs ± 0%−2.50%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4146µs ± 0%134µs ± 0%−8.42%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4160µs ± 0%161µs ± 0%+0.77%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.29ms ± 0%1.26ms ± 0%−2.04%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.39ms ± 0%1.34ms ± 0%−3.77%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.29ms ± 0%1.22ms ± 0%−6.01%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.37ms ± 0%1.26ms ± 0%−8.32%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.56ms ± 0%1.40ms ± 0%−10.28%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4135µs ± 0%116µs ± 0%−14.13%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4131µs ± 0%122µs ± 0%−6.83%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4130µs ± 0%124µs ± 0%−4.14%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4134µs ± 0%123µs ± 0%−8.37%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4145µs ± 0%138µs ± 0%−4.61%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.24ms ± 0%1.18ms ± 0%−5.30%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.32ms ± 0%1.21ms ± 0%−8.91%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.43ms ± 0%1.24ms ± 0%−13.54%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.45ms ± 0%1.27ms ± 0%−12.46%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.63ms ± 0%1.34ms ± 0%−17.78%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.7µs ± 0%8.5µs ± 0%−42.35%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%9.1µs ± 0%−24.00%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-410.7µs ± 0%12.1µs ± 0%+13.41%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-416.4µs ± 0%13.7µs ± 0%−16.32%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-419.1µs ± 0%16.5µs ± 0%−13.95%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4114µs ± 0%97µs ± 0%−15.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4113µs ± 0%102µs ± 0%−9.88%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4117µs ± 0%105µs ± 0%−10.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4132µs ± 0%132µs ± 0%−0.33%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4182µs ± 0%156µs ± 0%−14.03%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4130µs ± 0%134µs ± 0%+2.70%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4132µs ± 0%122µs ± 0%−7.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4144µs ± 0%122µs ± 0%−15.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4141µs ± 0%125µs ± 0%−11.30%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4136µs ± 0%126µs ± 0%−7.23%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.27ms ± 0%1.20ms ± 0%−5.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.27ms ± 0%1.22ms ± 0%−4.44%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.40ms ± 0%1.21ms ± 0%−13.57%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.24ms ± 0%1.28ms ± 0%+3.19%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.33ms ± 0%1.25ms ± 0%−5.49%(p=1.000 n=1+1)
 

@AndrewSisley AndrewSisley merged commit 7084daa into develop Apr 26, 2022
@AndrewSisley AndrewSisley deleted the sisley/refactor/I364-aggregate-query-restructure branch April 26, 2022 15:32
shahzadlone pushed a commit to shahzadlone/defradb that referenced this pull request Feb 23, 2024
* Restructure aggregate query syntax

In preparation for top-level queries, and aggregate filters

* Rework parser.GetAggregateSource

Should be a fair bit safer now and easier to read
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/query Related to the query component refactor This issue specific to or requires *notable* refactoring of existing codebases and components
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Aggregate: Rework aggregate query structure
5 participants