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.

Sign up for GitHub

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

Jump to bottom

test: Add test for deletion of records in a relationship #329

Merged
merged 3 commits into from
Apr 18, 2022
Merged

test: Add test for deletion of records in a relationship #329

merged 3 commits into from
Apr 18, 2022

Conversation

shahzadlone
Copy link
Member

resolves #221

These are non-transactional tests.

Should have some transactional tests too (@todo #328).

@shahzadlone shahzadlone added this to the DefraDB v0.3 milestone Apr 5, 2022
@shahzadlone shahzadlone self-assigned this Apr 5, 2022
@jsimnz jsimnz requested a review from AndrewSisley April 5, 2022 17:35
orpheuslummis
orpheuslummis reviewed Apr 5, 2022
View reviewed changes
db/tests/README.md Outdated Show resolved Hide resolved
orpheuslummis
orpheuslummis reviewed Apr 5, 2022
View reviewed changes
db/tests/README.md Outdated Show resolved Hide resolved
AndrewSisley
AndrewSisley reviewed Apr 5, 2022
View reviewed changes
db/tests/README.md
@@ -0,0 +1,20 @@
## Testing Guide
Copy link
Contributor

Choose a reason for hiding this comment

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

Readme looks good - cheers for adding this!

@shahzadlone shahzadlone force-pushed the lone/test/i-221-add-test-for-deletion-of-records-in-a-relationship branch from ac4110d to ce7b820 Compare April 5, 2022 18:09
orpheuslummis
orpheuslummis approved these changes Apr 5, 2022
View reviewed changes
Copy link
Contributor

@orpheuslummis orpheuslummis left a comment

Choose a reason for hiding this comment

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

LGTM

@shahzadlone shahzadlone force-pushed the lone/test/i-221-add-test-for-deletion-of-records-in-a-relationship branch from ce7b820 to f3446fa Compare April 5, 2022 20:38
@shahzadlone shahzadlone added action/no-benchmark Skips the action that runs the benchmark. area/testing Related to any test or testing suite labels Apr 5, 2022
@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-4301ms ± 0%221ms ± 0%−26.62%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-415.7ms ± 0%10.1ms ± 0%−35.41%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4147ms ± 0%119ms ± 0%−19.10%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.57s ± 0%1.06s ± 0%−32.13%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4509ms ± 0%441ms ± 0%−13.23%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.86s ± 0%4.56s ± 0%−6.11%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4468µs ± 0%351µs ± 0%−25.10%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.65ms ± 0%3.92ms ± 0%−15.85%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-445.1ms ± 0%39.0ms ± 0%−13.45%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4370µs ± 0%369µs ± 0%−0.17%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.05ms ± 0%3.99ms ± 0%−1.62%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4356µs ± 0%280µs ± 0%−21.23%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-42.21ms ± 0%1.83ms ± 0%−17.17%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-425.5ms ± 0%23.6ms ± 0%−7.65%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4274µs ± 0%247µs ± 0%−9.86%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.99ms ± 0%1.86ms ± 0%−6.41%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.31ms ± 0%1.23ms ± 0%−6.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.0ms ± 0%9.5ms ± 0%−5.28%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4586µs ± 0%453µs ± 0%−22.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.66ms ± 0%1.30ms ± 0%−21.68%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.8ms ± 0%10.1ms ± 0%−6.19%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4544µs ± 0%429µs ± 0%−21.03%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4545µs ± 0%473µs ± 0%−13.18%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4498µs ± 0%434µs ± 0%−12.83%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4908µs ± 0%852µs ± 0%−6.08%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4848µs ± 0%725µs ± 0%−14.51%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4701µs ± 0%665µs ± 0%−5.17%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4331µs ± 0%308µs ± 0%−6.97%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4567µs ± 0%478µs ± 0%−15.62%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-413.1ms ± 0%12.3ms ± 0%−6.43%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-417.4µs ± 0%13.6µs ± 0%−22.21%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-416.7µs ± 0%15.8µs ± 0%−5.42%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-419.1µs ± 0%18.9µs ± 0%−0.54%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.1µs ± 0%19.8µs ± 0%−10.29%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4154µs ± 0%134µs ± 0%−13.10%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4181µs ± 0%140µs ± 0%−22.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4180µs ± 0%145µs ± 0%−19.14%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4198µs ± 0%162µs ± 0%−18.24%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4242µs ± 0%197µs ± 0%−18.75%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-421.4µs ± 0%15.1µs ± 0%−29.55%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-418.0µs ± 0%15.0µs ± 0%−16.70%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-422.5µs ± 0%16.1µs ± 0%−28.55%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-426.9µs ± 0%17.3µs ± 0%−35.63%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.1µs ± 0%21.1µs ± 0%−29.74%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4187µs ± 0%144µs ± 0%−22.87%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4175µs ± 0%146µs ± 0%−16.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4193µs ± 0%160µs ± 0%−17.07%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4193µs ± 0%166µs ± 0%−14.00%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4237µs ± 0%227µs ± 0%−4.03%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-459.7µs ± 0%44.5µs ± 0%−25.48%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-465.3µs ± 0%46.9µs ± 0%−28.09%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-466.7µs ± 0%54.1µs ± 0%−18.89%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-472.2µs ± 0%53.0µs ± 0%−26.63%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-486.8µs ± 0%68.6µs ± 0%−20.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4514µs ± 0%402µs ± 0%−21.75%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4551µs ± 0%369µs ± 0%−33.05%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4490µs ± 0%392µs ± 0%−20.11%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4542µs ± 0%434µs ± 0%−20.01%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4624µs ± 0%535µs ± 0%−14.23%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-459.5µs ± 0%46.7µs ± 0%−21.55%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-462.7µs ± 0%49.9µs ± 0%−20.43%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-459.5µs ± 0%54.8µs ± 0%−7.91%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-476.0µs ± 0%54.4µs ± 0%−28.49%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-484.8µs ± 0%69.2µs ± 0%−18.37%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4502µs ± 0%378µs ± 0%−24.83%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4454µs ± 0%361µs ± 0%−20.51%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4473µs ± 0%367µs ± 0%−22.47%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4500µs ± 0%411µs ± 0%−17.97%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4549µs ± 0%493µs ± 0%−10.12%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4128µs ± 0%123µs ± 0%−3.84%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4128µs ± 0%127µs ± 0%−0.81%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4135µs ± 0%132µs ± 0%−2.57%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4158µs ± 0%143µs ± 0%−9.34%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.33ms ± 0%1.19ms ± 0%−10.52%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.37ms ± 0%1.26ms ± 0%−8.11%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.45ms ± 0%1.40ms ± 0%−3.90%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4155µs ± 0%119µs ± 0%−23.10%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4165µs ± 0%125µs ± 0%−23.79%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4173µs ± 0%122µs ± 0%−29.72%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4191µs ± 0%123µs ± 0%−35.80%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4183µs ± 0%135µs ± 0%−26.49%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.57ms ± 0%1.18ms ± 0%−25.06%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.51ms ± 0%1.28ms ± 0%−15.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.57ms ± 0%1.31ms ± 0%−16.21%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.73ms ± 0%1.32ms ± 0%−23.92%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.65ms ± 0%1.37ms ± 0%−16.65%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.8µs ± 0%8.4µs ± 0%−43.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%8.9µs ± 0%−25.56%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-414.8µs ± 0%10.8µs ± 0%−27.11%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-419.7µs ± 0%11.9µs ± 0%−39.76%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-416.5µs ± 0%15.3µs ± 0%−7.60%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4121µs ± 0%89µs ± 0%−26.84%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4138µs ± 0%102µs ± 0%−26.31%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4148µs ± 0%130µs ± 0%−12.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4193µs ± 0%183µs ± 0%−5.24%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4131µs ± 0%128µs ± 0%−2.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4149µs ± 0%126µs ± 0%−15.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4139µs ± 0%130µs ± 0%−6.89%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4153µs ± 0%139µs ± 0%−8.89%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4152µs ± 0%135µs ± 0%−11.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.40ms ± 0%1.21ms ± 0%−13.88%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.35ms ± 0%1.26ms ± 0%−6.52%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.49ms ± 0%1.31ms ± 0%−12.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.44ms ± 0%1.31ms ± 0%−9.25%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.40ms ± 0%1.33ms ± 0%−4.65%(p=1.000 n=1+1)
 
❌ See Worse Results...
time/opdelta
_Collection_UserSimple_Create_Async_0_100-458.0ms ± 0%60.2ms ± 0%+3.67%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4306µs ± 0%310µs ± 0%+1.45%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4280µs ± 0%282µs ± 0%+0.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.64ms ± 0%+3.77%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4123µs ± 0%133µs ± 0%+8.35%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.34ms ± 0%1.45ms ± 0%+7.81%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.42ms ± 0%1.49ms ± 0%+5.41%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4112µs ± 0%117µs ± 0%+3.97%(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-414.4ms ± 0%10.7ms ± 0%−25.30%(p=1.000 n=1+1)
_Collection_UserSimple_CreateMany_Sync_0_100-4301ms ± 0%221ms ± 0%−26.62%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_10-415.7ms ± 0%10.1ms ± 0%−35.41%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_100-4147ms ± 0%119ms ± 0%−19.10%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Sync_0_1000-41.57s ± 0%1.06s ± 0%−32.13%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_100-458.0ms ± 0%60.2ms ± 0%+3.67%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_1000-4509ms ± 0%441ms ± 0%−13.23%(p=1.000 n=1+1)
_Collection_UserSimple_Create_Async_0_10000-44.86s ± 0%4.56s ± 0%−6.11%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_10_10-4468µs ± 0%351µs ± 0%−25.10%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_100_100-44.65ms ± 0%3.92ms ± 0%−15.85%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_1000-445.1ms ± 0%39.0ms ± 0%−13.45%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_10-4370µs ± 0%369µs ± 0%−0.17%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Sync_1000_100-44.05ms ± 0%3.99ms ± 0%−1.62%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_10_10-4356µs ± 0%280µs ± 0%−21.23%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_100_100-42.21ms ± 0%1.83ms ± 0%−17.17%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_1000-425.5ms ± 0%23.6ms ± 0%−7.65%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_10-4274µs ± 0%247µs ± 0%−9.86%(p=1.000 n=1+1)
_Collection_UserSimple_Read_Async_1000_100-41.99ms ± 0%1.86ms ± 0%−6.41%(p=1.000 n=1+1)
pkg:github.com/sourcenetwork/defradb/bench/query/simple goos:linux goarch:amd64
_Query_UserSimple_Query_Sync_10-4450µs ± 0%360µs ± 0%−20.14%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_100-41.31ms ± 0%1.23ms ± 0%−6.05%(p=1.000 n=1+1)
_Query_UserSimple_Query_Sync_1000-410.0ms ± 0%9.5ms ± 0%−5.28%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_10-4586µs ± 0%453µs ± 0%−22.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_100-41.66ms ± 0%1.30ms ± 0%−21.68%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithFilter_Sync_1000-410.8ms ± 0%10.1ms ± 0%−6.19%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_10-4544µs ± 0%429µs ± 0%−21.03%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_100-4545µs ± 0%473µs ± 0%−13.18%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithLimitOffset_Sync_1000-4498µs ± 0%434µs ± 0%−12.83%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_10-4908µs ± 0%852µs ± 0%−6.08%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_100-4848µs ± 0%725µs ± 0%−14.51%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithMultiLookup_Sync_1000-4701µs ± 0%665µs ± 0%−5.17%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_10-4331µs ± 0%308µs ± 0%−6.97%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_100-4306µs ± 0%310µs ± 0%+1.45%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSingleLookup_Sync_1000-4280µs ± 0%282µs ± 0%+0.63%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_10-4567µs ± 0%478µs ± 0%−15.62%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_100-41.58ms ± 0%1.64ms ± 0%+3.77%(p=1.000 n=1+1)
_Query_UserSimple_Query_WithSort_Sync_1000-413.1ms ± 0%12.3ms ± 0%−6.43%(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-417.1µs ± 0%13.9µs ± 0%−18.69%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0128-417.4µs ± 0%13.6µs ± 0%−22.21%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0256-416.7µs ± 0%15.8µs ± 0%−5.42%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:0512-419.1µs ± 0%18.9µs ± 0%−0.54%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_10/ValueSize:1024-422.1µs ± 0%19.8µs ± 0%−10.29%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0064-4154µs ± 0%134µs ± 0%−13.10%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0128-4181µs ± 0%140µs ± 0%−22.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0256-4180µs ± 0%145µs ± 0%−19.14%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:0512-4198µs ± 0%162µs ± 0%−18.24%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_1_100/ValueSize:1024-4242µs ± 0%197µs ± 0%−18.75%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0064-421.4µs ± 0%15.1µs ± 0%−29.55%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0128-418.0µs ± 0%15.0µs ± 0%−16.70%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0256-422.5µs ± 0%16.1µs ± 0%−28.55%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:0512-426.9µs ± 0%17.3µs ± 0%−35.63%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_10/ValueSize:1024-430.1µs ± 0%21.1µs ± 0%−29.74%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0064-4187µs ± 0%144µs ± 0%−22.87%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0128-4175µs ± 0%146µs ± 0%−16.64%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0256-4193µs ± 0%160µs ± 0%−17.07%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:0512-4193µs ± 0%166µs ± 0%−14.00%(p=1.000 n=1+1)
_Storage_Simple_Read_Sync_100_100/ValueSize:1024-4237µs ± 0%227µs ± 0%−4.03%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0064-459.7µs ± 0%44.5µs ± 0%−25.48%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0128-465.3µs ± 0%46.9µs ± 0%−28.09%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0256-466.7µs ± 0%54.1µs ± 0%−18.89%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:0512-472.2µs ± 0%53.0µs ± 0%−26.63%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_10/ValueSize:1024-486.8µs ± 0%68.6µs ± 0%−20.96%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0064-4514µs ± 0%402µs ± 0%−21.75%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0128-4551µs ± 0%369µs ± 0%−33.05%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0256-4490µs ± 0%392µs ± 0%−20.11%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:0512-4542µs ± 0%434µs ± 0%−20.01%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_0_100/ValueSize:1024-4624µs ± 0%535µs ± 0%−14.23%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0064-459.5µs ± 0%46.7µs ± 0%−21.55%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0128-462.7µs ± 0%49.9µs ± 0%−20.43%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0256-459.5µs ± 0%54.8µs ± 0%−7.91%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:0512-476.0µs ± 0%54.4µs ± 0%−28.49%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_10/ValueSize:1024-484.8µs ± 0%69.2µs ± 0%−18.37%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0064-4502µs ± 0%378µs ± 0%−24.83%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0128-4454µs ± 0%361µs ± 0%−20.51%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0256-4473µs ± 0%367µs ± 0%−22.47%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:0512-4500µs ± 0%411µs ± 0%−17.97%(p=1.000 n=1+1)
_Storage_Simple_WriteMany_Sync_100_100/ValueSize:1024-4549µs ± 0%493µs ± 0%−10.12%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0064-4128µs ± 0%123µs ± 0%−3.84%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0128-4128µs ± 0%127µs ± 0%−0.81%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0256-4123µs ± 0%133µs ± 0%+8.35%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:0512-4135µs ± 0%132µs ± 0%−2.57%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_10/ValueSize:1024-4158µs ± 0%143µs ± 0%−9.34%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0064-41.33ms ± 0%1.19ms ± 0%−10.52%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0128-41.37ms ± 0%1.26ms ± 0%−8.11%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0256-41.45ms ± 0%1.40ms ± 0%−3.90%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:0512-41.34ms ± 0%1.45ms ± 0%+7.81%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_0_100/ValueSize:1024-41.42ms ± 0%1.49ms ± 0%+5.41%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0064-4155µs ± 0%119µs ± 0%−23.10%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0128-4165µs ± 0%125µs ± 0%−23.79%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0256-4173µs ± 0%122µs ± 0%−29.72%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:0512-4191µs ± 0%123µs ± 0%−35.80%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_10/ValueSize:1024-4183µs ± 0%135µs ± 0%−26.49%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0064-41.57ms ± 0%1.18ms ± 0%−25.06%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0128-41.51ms ± 0%1.28ms ± 0%−15.63%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0256-41.57ms ± 0%1.31ms ± 0%−16.21%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:0512-41.73ms ± 0%1.32ms ± 0%−23.92%(p=1.000 n=1+1)
_Storage_Simple_Write_Sync_100_100/ValueSize:1024-41.65ms ± 0%1.37ms ± 0%−16.65%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0064-414.8µs ± 0%8.4µs ± 0%−43.72%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0128-412.0µs ± 0%8.9µs ± 0%−25.56%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0256-414.8µs ± 0%10.8µs ± 0%−27.11%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:0512-419.7µs ± 0%11.9µs ± 0%−39.76%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_10_10/ValueSize:1024-416.5µs ± 0%15.3µs ± 0%−7.60%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0064-4121µs ± 0%89µs ± 0%−26.84%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0128-4112µs ± 0%117µs ± 0%+3.97%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0256-4138µs ± 0%102µs ± 0%−26.31%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:0512-4148µs ± 0%130µs ± 0%−12.09%(p=1.000 n=1+1)
_Storage_Simple_Txn_Read_Sync_100_100/ValueSize:1024-4193µs ± 0%183µs ± 0%−5.24%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0064-4131µs ± 0%128µs ± 0%−2.51%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0128-4149µs ± 0%126µs ± 0%−15.79%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0256-4139µs ± 0%130µs ± 0%−6.89%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:0512-4153µs ± 0%139µs ± 0%−8.89%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_10_1_10/ValueSize:1024-4152µs ± 0%135µs ± 0%−11.34%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0064-41.40ms ± 0%1.21ms ± 0%−13.88%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0128-41.35ms ± 0%1.26ms ± 0%−6.52%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0256-41.49ms ± 0%1.31ms ± 0%−12.22%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:0512-41.44ms ± 0%1.31ms ± 0%−9.25%(p=1.000 n=1+1)
_Storage_Simple_Txn_Iterator_Sync_100_1_100/ValueSize:1024-41.40ms ± 0%1.33ms ± 0%−4.65%(p=1.000 n=1+1)
 

@shahzadlone
Copy link
Member Author

Merge #333 before this to avoid looking at a ❌ failed build on develop history.

@shahzadlone shahzadlone force-pushed the lone/test/i-221-add-test-for-deletion-of-records-in-a-relationship branch from f3446fa to 4a6142d Compare April 18, 2022 05:46
@shahzadlone shahzadlone force-pushed the lone/test/i-221-add-test-for-deletion-of-records-in-a-relationship branch from 4a6142d to f33fbd6 Compare April 18, 2022 06:58
@shahzadlone shahzadlone merged commit deb2ffd into develop Apr 18, 2022
@shahzadlone shahzadlone deleted the lone/test/i-221-add-test-for-deletion-of-records-in-a-relationship branch April 18, 2022 07:19
shahzadlone added a commit to shahzadlone/defradb that referenced this pull request Feb 23, 2024
@shahzadlone
test: Add test for deletion of records in a relationship (sourcenetwo…
5fad445 
…rk#329)

resolves sourcenetwork#221

These are non-transactional tests.

Should have some transactional tests too (@todo sourcenetwork#328).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@AndrewSisley AndrewSisley AndrewSisley left review comments

@orpheuslummis orpheuslummis orpheuslummis approved these changes

@jsimnz jsimnz Awaiting requested review from jsimnz

Assignees

@shahzadlone shahzadlone

Labels
action/no-benchmark Skips the action that runs the benchmark. area/testing Related to any test or testing suite
Projects
None yet
Milestone
DefraDB v0.3
Development

Successfully merging this pull request may close these issues.

Add Tests for the Deletion of records in a relationship
4 participants
@shahzadlone @source-devs @orpheuslummis @AndrewSisley