Vinnie <thev...@yahoo.com> wrote: > So I'm getting SQLITE_BUSY now. I have one thread inserting rows > while another thread tries to read a row from the same table. I had a > bad implementation where I was keeping the transaction open far > longer than necessary so I think I went over some 5 second rule? Does > SQLite wait up some length of time before returning a "busy" error?
Not unless you ask it to - see sqlite3_busy_timeout. > How can I tell SQLite to wait forever? You could specify a really large value in sqlite3_busy_timeout. Not forever, but 0x7FFFFFFF is about 24 days in milliseconds. > Is this something desirable? That's for you to decide. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
