On Thu, Aug 15, 2013 at 3:39 PM, Gary Weaver <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
