logoalt Hacker News

Oxlamarrtoday at 10:00 AM1 replyview on HN

Very cool. Is the bottleneck under load mostly SQLite write throughput, or the WAL notification layer?


Replies

russellthehippotoday at 11:11 AM

writes and claim/ack flow. really depends on your journal mode and synchrnous mode as well.

notifs are extremely cheap, either in the old stat(2) mode or the new PRAGMA page_version (see my update on feeback comment). Some other comments mentioned that stat(2) is about 1µs.