[sqlite] Sqlite - Multithreading

All, According to the documentation.. "When any process wants to write, it must lock the entire database file for the duration of its update. But that normally only takes a few milliseconds. Other processes just wait on the writer to finish then continue about their business" Does sqlite take

Re: [sqlite] sqlite & multithreading

On Feb 7, 2005, at 10:21 AM, Alex Chudnovsky wrote: Correct me if I am wrong but I was under the impression that having 2 separate connections to database (and while on subject I noticed that making connection via ADO.NET takes significant time measured in seconds rather than in milliseconds)

Re: [sqlite] sqlite & multithreading

[EMAIL PROTECTED] wrote: On Feb 7, 2005, at 9:50 AM, Yogesh Marwaha wrote: Both threads are using same sqlite connection. This is your problem. Each thread should use an isolated connection. Correct me if I am wrong but I was under the impression that having 2 separate connections to database

[sqlite] sqlite & multithreading

Hi! Problem: 1 - I need some help using sqlite3 with multithreading. Here is an overview of present situation: - I am using sqlite 3.0.8 I have two threads (A & B) working at the same time. Thread A is used to query database while thread B is being used for writing to the database.