Re: [sqlite] SQLITE_OPEN_NOMUTEX

2014-01-02 Thread Richard Hipp
On Thu, Jan 2, 2014 at 1:23 PM, Prakash Reddy Bande wrote:

> Hi,
>
> As per documentation opening a database with SQLITE_OPEN_NOMUTEX flag
> opens it in multi-threaded mode.
> http://www.sqlite.org/threadsafe.html says In this mode, SQLite can be
> safely used by multiple threads provided that no single database connection
> is used simultaneously in two or more threads.
>
> I just wanted to be certain that this is true in case of multi-cpu
> machines and cache-coherence related issues won't surface.
>

Confirmed.  As long as you don't use the same database connection on
multiple threads/cores at the same time, you will be fine.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] SQLITE_OPEN_NOMUTEX

2014-01-02 Thread Prakash Reddy Bande
Hi,

As per documentation opening a database with SQLITE_OPEN_NOMUTEX flag opens it 
in multi-threaded mode.
http://www.sqlite.org/threadsafe.html says In this mode, SQLite can be safely 
used by multiple threads provided that no single database connection is used 
simultaneously in two or more threads.

I just wanted to be certain that this is true in case of multi-cpu machines and 
cache-coherence related issues won't surface.

Regards,

Prakash Bande
Director - Hyperworks Enterprise Software
Altair Eng. Inc.
Troy MI
Ph: 248-614-2400 ext 489
Cell: 248-404-0292

My Secure Drop Box: https://ftam1.altair.com/dropbox/~Ursfnk

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users