On Thu, Aug 15, 2013 at 3:39 PM, Gary Weaver <garyswea...@gmail.com> wrote:

>
> Is there anything that stands out as something that would keep 30
> processes from being able to concurrently insert into the same tables?
>

Yes.  SQLite does not (and has never) supported that.  Multiple processes
can read from the same database at the same time, but only one can be
writing at any given time.  Multiple writers have to take turns.

SQLite serializes the writers using posix advisory locks (on unix) by
default and unless the application has done something unusual to disable
the locking.  But posix advisory locks are sometimes broken on network
filesystems.  Is the database being stored on a network filesystem?

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

Reply via email to