Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

I have found it easy to overload SQLite with too many write operations (20+ Concurrently), is this typical behaviour referred to in the post, or a write heavy workload?


It can depends on a lot of factors such as the journaling mode you're using as well as your hardware. SQLite has a single-writer-at-a-time restriction so it's important manage the size of your writes. I typically see very good write throughput using WAL mode and synchronous=normal on modern SSDs.


How big are the writes? are you storing blobs?




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: