On Feb 3, 2009, at 3:12 PM, Brandon, Nicholas (UK) wrote:
> I'm open to other techniques particularly if they would be simpler to
> implement and manage!
Using a queue of DML statements sound very reasonable :)
Nanoki [1] uses that technique when indexing text documents with fts3:
(1) A reques
While I'm not sure how long your long running select would take, it
seems like SQLite (at least version 3) already works the way you are
describing. As soon as you issue a select against a database file a
shared lock is obtained. On commit that shared lock is released.
While you have a shared com
2 matches
Mail list logo