Happened all the time to me before I did some tuning Depends how much write cont... | Hacker News

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

		nikisweeting on Sept 12, 2024 \| parent \| context \| favorite \| on: SQLite on Rails: The how and why of optimal perfor... Happened all the time to me before I did some tuning Depends how much write contention you have and how long open transactions take to finish.

rbranson on Sept 12, 2024 [–]

The list of circumstances for WAL-mode busy errors is in the doc linked by one of the posters above. It has nothing to do with transactions.

ncruces on Sept 13, 2024 | [–]

That list lists reasons queries might return busy; queries aka. reads.

Reads returning busy is rare under WAL, but WAL mode does very little for writer-writer contention.

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