2 May
2008
2 May
'08
8:58 p.m.
On 2. mai. 2008, at 22.25, Paul J Stevens wrote:
just table lock issues under high concurrencies. And those are pretty much unavoidable I guess
Increasing timeout can help reduce the lock issue in SQLite. Try to increase Connection_setQueryTimeout() to e.g. 5000. Default is 3000. Its a trade off, but if you run a request per thread its usually better to have the statement go through and live with an occasional spike in throughput.