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

SQLite, for the most part, uses polling locks. That means it checks if a lock is available to be taken, and if it's not, it sleeps for a bit, then checks again, until this times out.

This becomes increasingly inefficient as contention increases, as you can easily get into a situation where everyone is sleeping, waiting for others, for a few milliseconds.

Ensuring all, or most, writes are serialized, improves this.



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

Search: