Researchers from the University of Helsinki and Cambridge aim to make SQLite even faster with their paper on “Serverless Runtime / Database Co-Design With Asynchronous I/O”. They explore the use of asynchronous I/O and storage disaggregation to demonstrate a 100x reduction in tail latency. Their work serves as the foundation for Limbo, a SQLite rewrite in Rust that leverages io_uring for improved performance. The paper delves into the intricacies of query execution in SQLite and the benefits of utilizing asynchronous I/O. The results of their benchmarking show significant improvements in tail latency with Limbo compared to traditional SQLite, highlighting the promising potential of this approach.
https://avi.im/blag/2024/faster-sqlite/