答复: [sqlite] multi_thread for writing

2005-04-17 Thread RexChan\(TP/HK\)
rg Subject: Re: [sqlite] multi_thread for writing As far as I know, SQLite does not support multiple simultaneous writers. I believe you need to be ready to handle SQLITE_BUSY and SQLITE_SCHEMA errors on every call in a multi- threaded application. SQLITE_BUSY... http://www.sqlite.org/cvst

Re: [sqlite] multi_thread for writing

2005-04-16 Thread Kervin L. Pierre
As far as I know, SQLite does not support multiple simultaneous writers. I believe you need to be ready to handle SQLITE_BUSY and SQLITE_SCHEMA errors on every call in a multi- threaded application. SQLITE_BUSY... http://www.sqlite.org/cvstrac/wiki?p=MultiThreading SQLITE_SCHEMA... http://www.s

[sqlite] multi_thread for writing

2005-04-16 Thread RexChan\(TP/HK\)
Hi all, I meet the problem of multi_thread writing in version 3.2.1. First I create two threads A and B and each thread has its own db structure. each thread uses the following SQL commands to do the insert action. BEGIN; . insert record 200 times . . END; Thread A does the insert first an