4 ms·
How will it affect other SQLite connections against the same database? My guess is they'll be OK, but presumably any transactions will lock tables for the dura
by simonw 4y ago
How will it affect other SQLite connections against the same database?
My guess is they'll be OK, but presumably any transactions will lock tables for the duration?
- alexgarcia-xyz 4y agoI think you're right, tho not an expert with multiple connections. I think if the DB is in WAL mode and you're only issuing read-only requests, then there will be no lock and long HTTP requests won't lock anything up. But if you issue a write-request that locks tables, then other write-requests will be blocked with long requests. But if you're in journal mode then there's not much you can do. Please correct me if I'm wrong!