corpus.blog
56,966 blogs · 4,417,066 posts Claim your blog
Record · corpus.blog/posts/01a087a7-cc11-7124-8532-d393218be17b

From 19k to 4.2M events/sec: story of a SQLite query optimisation

mnt.io · published 12 September 2025

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at mnt.io Wayback capture
2blogs citing
First cited
28 Sept 2025
Most recent
30 Oct 2025
Rank this month
not ranked
Links from this post
32
Words captured
4,284

Cited by

Blog
In the post
Date
vrutkovs.eu
27-31 October 2025 Read at the source ↗
30 Oct 2025
jordivillar.com
2025W38 Read at the source ↗
28 Sept 2025

Links from this post

Link
Host
https://github.com/matrix-org/matrix-rust-sdk
github.com
https://matrix.org/
matrix.org
https://sqlite.org/
sqlite.org
https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API
developer.mozilla.org
https://docs.rs/matrix-sdk-common/0.14.0/matrix_sdk_common/linked_chunk/index.html
docs.rs
https://en.wikipedia.org/wiki/Linked_List
en.wikipedia.org
https://spec.matrix.org/v1.15/client-server-api/
spec.matrix.org
https://github.com/element-hq/element-x-ios-rageshakes/issues/4248
github.com
https://docs.rs/matrix-sdk-common/0.14.0/matrix_sdk_common/tracing_timer/struct.TracingTimer.html
docs.rs
https://docs.rs/tracing/
docs.rs
https://docs.rs/matrix-sdk-common/0.14.0/matrix_sdk_common/macro.timer.html
docs.rs
https://github.com/mstange/samply
github.com
https://github.com/firefox-devtools/profiler
github.com
https://github.com/matrix-org/matrix-rust-sdk/pull/5407
github.com
https://github.com/BurntSushi/ripgrep
github.com
https://sqlite.org/lang_createindex.html
sqlite.org
https://en.wikipedia.org/wiki/Database_index
en.wikipedia.org
https://spec.matrix.org/v1.15/appendices/
spec.matrix.org
https://sqlite.org/arch.html
sqlite.org
https://sqlite.org/lang_expr.html
sqlite.org
https://mnt.io/articles/from-19k-to-4-2m-events-per-sec-story-of-a-sqlite-query-optimisation/./1-pdf.svg
mnt.io
https://mnt.io/articles/from-19k-to-4-2m-events-per-sec-story-of-a-sqlite-query-optimisation/./1-iteration-times.svg
mnt.io
https://mnt.io/articles/from-19k-to-4-2m-events-per-sec-story-of-a-sqlite-query-optimisation/./2-pdf.svg
mnt.io
https://mnt.io/articles/from-19k-to-4-2m-events-per-sec-story-of-a-sqlite-query-optimisation/./2-linear-regression.svg
mnt.io
https://github.com/matrix-org/matrix-rust-sdk/pull/5411
github.com
https://mnt.io/articles/from-19k-to-4-2m-events-per-sec-story-of-a-sqlite-query-optimisation/./3-pdf.svg
mnt.io
https://mnt.io/articles/from-19k-to-4-2m-events-per-sec-story-of-a-sqlite-query-optimisation/./3-linear-regression.svg
mnt.io
https://github.com/matrix-org/matrix-rust-sdk/pull/5425
github.com
https://bheisler.github.io/criterion.rs/book/index.html
bheisler.github.io
https://sqlite.org/queryplanner-ng.html
sqlite.org
https://bouvier.cc/
bouvier.cc
https://github.com/poljar
github.com