Avatar for the matrix-org user
matrix-org
matrix-rust-sdk
BlogDocsChangelog

Refactor/improve performance sqlite db

#5472
Comparing
multisme:refactor/improve_performance_sqlite_db
(
eca9e89
) with
main
(
b6433de
)
CodSpeed Performance Gauge
0%
Improvements
0
Regressions
0
Untouched
37
New
0
Dropped
0
Ignored
0

Benchmarks

Passed

Linked chunk lazy loader[memory store][100]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk lazy loader[memory store][100]
CodSpeed Performance Gauge
+4%
190.4 µs
182.3 µs
Linked chunk lazy loader[memory store][10]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk lazy loader[memory store][10]
CodSpeed Performance Gauge
+1%
34.4 µs
34 µs
Linked chunk writing [none][10]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [none][10]
CodSpeed Performance Gauge
+1%
15.5 µs
15.4 µs
Room key sharing [SQLite][163 devices]
benchmarks/benches/crypto_bench.rs::benches::room_key_sharing::Room key sharing::Room key sharing [SQLite][163 devices]
CodSpeed Performance Gauge
+1%
57.8 ms
57.5 ms
Room key sharing [memory][163 devices]
benchmarks/benches/crypto_bench.rs::benches::room_key_sharing::Room key sharing::Room key sharing [memory][163 devices]
CodSpeed Performance Gauge
+1%
46.7 ms
46.4 ms
Linked chunk lazy loader[sqlite store][100]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk lazy loader[sqlite store][100]
CodSpeed Performance Gauge
+1%
1.7 ms
1.7 ms
Linked chunk metadata loader[memory store][100]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk metadata loader[memory store][100]
CodSpeed Performance Gauge
0%
20.9 µs
20.8 µs
Linked chunk writing [sqlite store][1000]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [sqlite store][1000]
CodSpeed Performance Gauge
0%
20 ms
19.9 ms
Linked chunk metadata loader[sqlite store][100]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk metadata loader[sqlite store][100]
CodSpeed Performance Gauge
0%
245 µs
244.2 µs
Linked chunk writing [memory store][10]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [memory store][10]
CodSpeed Performance Gauge
0%
52.4 µs
52.2 µs
Restore session [SQLite][encrypted]
benchmarks/benches/store_bench.rs::benches::restore_session::Client reload::Restore session [SQLite][encrypted]
CodSpeed Performance Gauge
0%
1.2 s
1.2 s
Linked chunk lazy loader[sqlite store][1000]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk lazy loader[sqlite store][1000]
CodSpeed Performance Gauge
0%
15 ms
14.9 ms
Linked chunk writing [none][100]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [none][100]
CodSpeed Performance Gauge
0%
85.3 µs
85.1 µs
Event cache room updates[SQLite][room count: 1]
benchmarks/benches/event_cache.rs::event_cache::handle_room_updates::Event cache room updates::Event cache room updates[SQLite][room count: 1]
CodSpeed Performance Gauge
0%
34.4 ms
34.4 ms
Event cache room updates[memory][room count: 10]
benchmarks/benches/event_cache.rs::event_cache::handle_room_updates::Event cache room updates::Event cache room updates[memory][room count: 10]
CodSpeed Performance Gauge
0%
162.2 ms
162 ms
Device keys query [SQLite][153 device and cross signing keys]
benchmarks/benches/crypto_bench.rs::benches::keys_query::Keys querying::Device keys query [SQLite][153 device and cross signing keys]
CodSpeed Performance Gauge
0%
40 ms
40 ms
Linked chunk metadata loader[memory store][1000]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk metadata loader[memory store][1000]
CodSpeed Performance Gauge
0%
758 µs
757.7 µs
Linked chunk metadata loader[sqlite store][1000]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk metadata loader[sqlite store][1000]
CodSpeed Performance Gauge
0%
1.2 ms
1.2 ms
Event cache room updates[SQLite][room count: 10]
benchmarks/benches/event_cache.rs::event_cache::handle_room_updates::Event cache room updates::Event cache room updates[SQLite][room count: 10]
CodSpeed Performance Gauge
0%
355.7 ms
355.9 ms
Linked chunk lazy loader[sqlite store][10]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk lazy loader[sqlite store][10]
CodSpeed Performance Gauge
0%
423.6 µs
423.7 µs
Linked chunk writing [none][1000]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [none][1000]
CodSpeed Performance Gauge
0%
794.3 µs
794.7 µs
Linked chunk writing [sqlite store][10]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [sqlite store][10]
CodSpeed Performance Gauge
0%
502.2 µs
502.5 µs
Device keys query [memory][153 device and cross signing keys]
benchmarks/benches/crypto_bench.rs::benches::keys_query::Keys querying::Device keys query [memory][153 device and cross signing keys]
CodSpeed Performance Gauge
0%
27.7 ms
27.7 ms
Linked chunk metadata loader[memory store][10]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk metadata loader[memory store][10]
CodSpeed Performance Gauge
0%
5.6 µs
5.6 µs
Event cache room updates[memory][room count: 1]
benchmarks/benches/event_cache.rs::event_cache::handle_room_updates::Event cache room updates::Event cache room updates[memory][room count: 1]
CodSpeed Performance Gauge
0%
15.9 ms
15.9 ms
Linked chunk writing [memory store][1000]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [memory store][1000]
CodSpeed Performance Gauge
0%
3.6 ms
3.6 ms
Linked chunk metadata loader[sqlite store][10]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk metadata loader[sqlite store][10]
CodSpeed Performance Gauge
0%
172.1 µs
172.3 µs
Event cache room updates[SQLite][room count: 100]
benchmarks/benches/event_cache.rs::event_cache::handle_room_updates::Event cache room updates::Event cache room updates[SQLite][room count: 100]
CodSpeed Performance Gauge
0%
3.8 s
3.8 s
Restore session [memory store]
benchmarks/benches/store_bench.rs::benches::restore_session::Client reload::Restore session [memory store]
CodSpeed Performance Gauge
0%
180.7 ms
181 ms
Event cache room updates[memory][room count: 100]
benchmarks/benches/event_cache.rs::event_cache::handle_room_updates::Event cache room updates::Event cache room updates[memory][room count: 100]
CodSpeed Performance Gauge
0%
1.6 s
1.6 s
Restore session [SQLite][clear]
benchmarks/benches/store_bench.rs::benches::restore_session::Client reload::Restore session [SQLite][clear]
CodSpeed Performance Gauge
0%
635.3 ms
636.7 ms
Linked chunk writing [sqlite store][100]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [sqlite store][100]
CodSpeed Performance Gauge
0%
2 ms
2 ms
Create a timeline with initial events[10000 events]
benchmarks/benches/timeline.rs::room::create_timeline_with_initial_events::Create a timeline::Create a timeline with initial events[10000 events]
CodSpeed Performance Gauge
0%
729.3 ms
731.5 ms
Devices collecting [SQLite][2003 devices]
benchmarks/benches/crypto_bench.rs::benches::devices_missing_sessions_collecting::Devices missing sessions collecting::Devices collecting [SQLite][2003 devices]
CodSpeed Performance Gauge
0%
113.2 ms
113.6 ms
Devices collecting [memory][2003 devices]
benchmarks/benches/crypto_bench.rs::benches::devices_missing_sessions_collecting::Devices missing sessions collecting::Devices collecting [memory][2003 devices]
CodSpeed Performance Gauge
0%
10.7 ms
10.7 ms
Linked chunk lazy loader[memory store][1000]
benchmarks/benches/linked_chunk.rs::event_cache::reading::Linked chunk reading::Linked chunk lazy loader[memory store][1000]
CodSpeed Performance Gauge
0%
2.4 ms
2.4 ms
Linked chunk writing [memory store][100]
benchmarks/benches/linked_chunk.rs::event_cache::writing::Linked chunk writing::Linked chunk writing [memory store][100]
CodSpeed Performance Gauge
-1%
354 µs
357.8 µs

Commits

Click on a commit to change the comparison range
Base
main
b6433de
+0.3%
Correct wrong borrow
9718b79
27 days ago
by multisme
-0.33%
reformat
601893b
23 days ago
by multisme
+0.58%
Update changelog
f7a24ed
13 days ago
by multisme
+0.24%
Merge branch 'matrix-org:main' into refactor/improve_performance_sqlite_db
7c8b3c5
13 days ago
by multisme
-0.97%
Reimplement previous tests for the store and on top of the one testing the opening with a key
d930a36
13 days ago
by multisme
+0.25%
Replace missing line
d8dfda6
13 days ago
by multisme
+0.09%
Merge branch 'matrix-org:main' into refactor/improve_performance_sqlite_db
eca9e89
13 days ago
by multisme
© 2025 CodSpeed Technology
Home Terms Privacy Docs