34 ms·
yeah, but that will slow down your app and may help in a short run, but you basically just shift the problem and make it even worse if your workload gets even h
by abbbi 3y ago
yeah, but that will slow down your app and may help in a short run, but you basically just shift the problem and make it even worse if your workload gets even higher.
- duped 3y agoThen use a different busy handler
- gwd 3y agoYou should only be waiting if someone else is writing. And yes, disallowing any concurrent writes, as SQLite does, is certainly going to be a bottleneck at some point, but unless you have a particularly write-heavy workload, it will probably get you pretty far.