On May 25, 2010, at 10:24 PM, Nick Shaw wrote: > Hi all, > > > > I've got a database that is accessed by two processes on the same PC. > When I add a large number of records to a table from one process (all > records wrapped in a BEGIN DEFERRED / END so it's committed to disk > all > at once; and we're talking about adding 500,000 recs to a DB > containing > around 3 million recs, so it takes some time), the other process gets > stuck in the sqlite3_step() call when doing a SELECT call. It doesn't > return SQLITE_BUSY, it just sits there waiting.
Is it possible you have a busy-handler installed? Are you using SQLite directly or via some wrapper API? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
