Optimizing SQLite for servers

Sylvain Kerkour, February 15, 2024: Optimizing SQLite for servers

ByteA

Alvaro Herrera on pgsql-general: if you set ALTER TABLE tab ALTER COLUMN byt SET STORAGE EXTERNAL then compression is not used, and random access becomes fast.

INP

Interaction to Next Paint (INP)

gzip performance

1st, some old data: https://www.hjp.at/zettel/g/gzip-performance.html tar.gz of a posgresql db (ca. 2TB. compression ratio 1:9). compression: 7:48 hours. 68e6 B/s. 246e9 B/h decompression: 1:50 hours, 294e6 B/s, 1e12 B/h

How io_uring and eBPF Will Revolutionize Programming in Linux

How io_uring and eBPF Will Revolutionize Programming in Linux

BPF Compiler Collection (BCC)

Githug Project Page Examples: How to Use BCC Kernel Tracing Tools for Linux Performance Analysis How to measure Linux Performance Avoiding Most Typical Mistakes: CPU

Async Python is not faster

Under realistic conditions (see below) asynchronous web frameworks are slightly worse throughput (requests/second) and much worse latency variance. Async Python is not faster