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 request for indexing a document is enqueued and return immediately (2) When the system is idle, the request is processed Additionally, the database itself is partitioned across a number of sqlite files, so a write statement only briefly lock only one physical sqlite file [2]. FWIW, here is the related DML: http://dev.alt.textdrive.com/browser/HTTP/Finder.dml HTH. Cheers, -- PA. http://alt.textdrive.com/nanoki/ [1] http://svr225.stepx.com:3388/nanoki [2] http://en.wikipedia.org/wiki/Shard_(database_architecture) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
