"Rob Richardson" <[EMAIL PROTECTED]> wrote: > I found the spot where I was telling the two threads to use the same > database pointer instead of running on separate ones. Once I fixed > that, it works. >
It has been suggested that I add a mutex to every SQLite database connection. This would cause access to a database connection to automatically serialize even when two or more threads try to use that connection at once, thus preventing problems such as the above. The downside is the (minimal) additional overhead of acquiring and releasing a mutex on each API call. There will also be some changes to the OS-layer backend which will break private ports to unusual OSes. Thoughts? -- D. Richard Hipp <[EMAIL PROTECTED]>
