[sqlite] All threads are frozen during the timeout if SQLITE is busy

2016-02-09 Thread olivier vidal
Good ideas! thank you Mr Hipp! > Richard Hipp > mardi 9 f?vrier 2016 13:00 > > The interface that governs the timeout is "sqlite3_busy_handler()". > Perhaps you can modify its callback to yield to another thread, rather > than simply sleeping. Or just set the timeout

[sqlite] All threads are frozen during the timeout if SQLITE is busy

2016-02-09 Thread olivier vidal
Hello, I use SQLITE with Xojo (formerly Realbasic), a kind of VB multiplatform. Xojo embeds a SQLITE 3.9.2 database. It works well. But I have a concern, and I do not know if it is a Xojo problem, or a SQLITE problem. I am creating an application with Xojo/Sqlite. This application launches

[sqlite] All threads are frozen during the timeout if SQLITE is busy

2016-02-09 Thread olivier vidal
Hello, I use SQLITE with Xojo (formerly Realbasic), a kind of VB multiplatform. Xojo embeds a SQLITE 3.9.2 database. It works well. But I have a concern, and I do not know if it is a Xojo problem, or a SQLITE problem. I am creating an application with Xojo/Sqlite. This application launches

[sqlite] All threads are frozen during the timeout if SQLITE is busy

2016-02-09 Thread Richard Hipp
On 2/9/16, olivier vidal wrote: > > - One thread writes > - While this thread wrote, another thread requests to write. Of course, > a "busy" error is generated, this is normal. But until the error is > generated, all threads in the application are frozen during the sqlite > timeout! > > I tried