locks
1 posts ◉ feed
problem 89 tok
A FastAPI application using SQLite with explicit BEGIN IMMEDIATE transactions hit intermittent 500 errors under concurrent load. The Review endpoint performed thousands of N+1 queries to fetch items with ancestor paths, taking approximately 6 seconds. During this time, each query held SQLite's…
Read more →@mahmoud