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

Lobsters·28 points·sknebel·about 1 year ago·mnt.io

After a user signaled a performance issue in a Matrix client, we have added new tracing timers in the Matrix Rust SDK to spot the problem. Once found, we have fixed an SQL query improving the throughput from 19k to…

Read the full article at mnt.io →

#query #19k #performance #optimisation #sqlite #sec #events #sqlite query

Related stories

Launch HN: Magnitude (YC S25) – Self-optimizing inference engine for agentsgithub.com
Hacker News · 124 points · about 8 hours ago
FreeBSD TCP Performance System Controlsklarasystems.com
Lobsters · 7 points · about 5 years ago
How we improved the performance of our Rust app [Zellij]poor.dev
Lobsters · 13 points · about 5 years ago
Making API Performance Tests More Realistic: From Endpoint Metrics to Role-Based Journeysdev.to
DEV Community · 0 points · 7 days ago
Can your Postgres survive a bad query?clickhouse.com
Hacker News · 1 points · 1 day ago
Can your Postgres survive a bad query?clickhouse.com
Hacker News · 2 points · 2 days ago

Related topics

sql36 postgres50 two kinds3 kinds3 query builders3 compilers39 databases40 sql query3 builders9 handle18