SQLite WAL Mode Benchmark in Python: DELETE vs WAL Numbers
In my Python benchmark, SQLite WAL with synchronous=FULL ran 10,000 single-row inserts about 4.1x faster than DELETE mode and had 0 BUSY errors against 62 writer and 117 reader.
3 articles tagged with #Benchmarks
In my Python benchmark, SQLite WAL with synchronous=FULL ran 10,000 single-row inserts about 4.1x faster than DELETE mode and had 0 BUSY errors against 62 writer and 117 reader.
Change one integer inside an 8 KB JSONB document and PostgreSQL 17 writes about 16,300 bytes of WAL. Change the same integer when it lives in its own column and it writes 294 bytes. That 55x gap…
Laravel Octane benchmark of FrankenPHP, Swoole, RoadRunner and PHP-FPM in Docker: three-run laptop numbers, full setup, what breaks under Octane, and when to switch.