Get the latest tech news

In Search of a Faster SQLite


Researchers at the University of Helsinki and Cambridge attempted to build a faster SQLite using modern programming paradigms like io_uring and disaggregated storage. They demonstrate up to a 100x reduction in tail latency. These are my notes.

It allows the application to submit an I/O request and concurrently perform other tasks until it receives a notification from the OS on the com- pletion of the I/O operation. The sqlite3_step() function executes the sequence of bytecode instructions until the query produces a row to read, or it com- pletes. Mapping table-like data into a KV model leads to poor developer experience and (de)serialization costs.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Search

Search

Related news:

News photo

Big Tech Will Scour the Globe in Its Search for Cheap Energy

News photo

A 'Year in Search' highlights Google's top trends across AI and shows in 2024

News photo

SQLite Index Visualization: Search