Re: [sqlite] Use of in memory db

2009-08-03 Thread Igor Tandetnik
Sharma, Gaurav wrote: > Please clear my one more doubt. Is it true that either using the > SQLITE_THREADSAFE=1 as compile time flag or using > SQLITE_OPEN_FULLMUTEX with sqlite3_open_v2 are same thing. Both can > be used interchangeably. Correct me if I am wrong. Once you compile with

Re: [sqlite] Use of in memory db

2009-08-03 Thread Sharma, Gaurav
Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Thursday, July 30, 2009 5:10 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Use of in memory db > What I assume is if I share an in memory db connection han

Re: [sqlite] Use of in memory db

2009-07-30 Thread Igor Tandetnik
Sharma, Gaurav wrote: > Is there any way through which without using the mutex lock mechanism > multiple threads can perform INSERT in bulk on same memory db. What I > assume is if I share an in memory db connection handle across threads > then it will not be sqlite's responsibility but the user's

Re: [sqlite] Use of in memory db

2009-07-30 Thread Pavel Ivanov
> What I assume is if I share an in memory db connection handle across threads > then it will not be sqlite's responsibility but the user's responsibility to > protect multiple insert/update statements. On the other hand if the > connection to physical db is shared amongst threads then sqlite