🚀Turso PR Implements Readahead, Boosts SQEs by 23K
Turso's readahead PR slashes SQEs, speeds up queries
TL;DR
Turso's new PR implements readahead, boosting SQEs by 23,005 and reducing device requests. This speeds up TPC-H queries on large databases, a win for analytic workloads.
Turso's PR implements readahead, boosting SQEs by 23,005 and reducing device requests. This speeds up TPC-H queries on large databases, a win for analytic workloads. Without readahead, Turso issues SQEs one at a time, leading to slower performance. With readahead, Turso submits reads for multiple pages, merging requests and reducing overhead. The PR's code without readahead submitted 195,207 SQEs, while with readahead, it submitted 218,493 SQEs, showing a significant improvement in efficiency.
Key Points
Turso's PR boosts SQEs by 23,005 with readahead enabled.
Without readahead, Turso issues SQEs one at a time, leading to slower performance.
With readahead, Turso submits reads for pages 100 through 131, merging requests.
The PR's code without readahead submitted 195,207 SQEs, while with readahead, it submitted 218,493 SQEs.
The device received fewer requests with readahead on, reducing overhead.
Why It Matters
If you're running large analytic databases on Turso, this PR flips the economics. TPC-H queries see a significant speedup, reducing the number of SQEs and device requests. This is crucial for teams relying on Turso for high-performance analytics.
Frequently Asked Questions
Why does this matter?
If you're running large analytic databases on Turso, this PR flips the economics. TPC-H queries see a significant speedup, reducing the number of SQEs and device requests. This is crucial for teams relying on Turso for high-performance analytics.
What happened?
Turso's new PR implements readahead, boosting SQEs by 23,005 and reducing device requests. This speeds up TPC-H queries on large databases, a win for analytic workloads.
Comments
Be the first to comment
Enjoyed this article?
Get it daily. 7am. Free. Reads in 5 minutes.
Join 3,436 builders reading daily.