Hello Richard, I set the busy timeout to zero and manage the errors in my code with delays and retries. What I found is I couldn't pick a busy timeout value that was always correct.
Friday, November 28, 2008, 8:12:06 PM, you wrote: RK> Hi Alexey, RK> Thanks for your link, but it is not really click me too well RK> I should set this busy_timeout to longer ms than current ? RK> Richard K RK> -----Original Message----- RK> From: [EMAIL PROTECTED] RK> [mailto:[EMAIL PROTECTED] On Behalf Of Alexey Pechnikov RK> Sent: Friday, November 28, 2008 3:00 PM RK> To: General Discussion of SQLite Database RK> Subject: Re: [sqlite] concurrent write RK> Hello! RK> В сообщении от Saturday 29 November 2008 01:16:17 Richard Kim написал(а): >> We have database table, and it is being written, sometimes 30 times a >> second. >> Some of the data succeeded, but some aren't. >> >> How should we handle this sort of lock issue ? RK> http://www.sqlite.org/c3ref/busy_timeout.html RK> Best regards, Alexey. RK> _______________________________________________ RK> sqlite-users mailing list RK> sqlite-users@sqlite.org RK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users RK> _______________________________________________ RK> sqlite-users mailing list RK> sqlite-users@sqlite.org RK> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:[EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users