sqlite3 read/write operations time out during writes
Walter GR <[email protected]> Fri, 31 Dec 2010 16:49:56 -0800
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
SQLite locks tables when performing table writes or deletes. This blocks any reads, writes, or deletes that come in at the same time. Using CL-SQL, I get frequent timeouts while performing a simple, short-lived update on one thread and a read on another. These are so frequent, it appears to me that the timeout is set to 0 msec. How can I increase the timeout? It seems like CL-SQL should default to a timeout greater than 0 msec. Thoughts? Thanks, Walter -- The Online Slang Dictionary - Now a wiki! http://onlineslangdictionary.com/