I think this will change with SQLite 3.7's new Write Ahead Logging (WAL) feature. Over in the Berkeley DB team we have put a btree that implements transactional storage based on WAL under the SQLite parser/processor. This technique can support a different locking model and lead to a very high degree of concurrency resulting in good scalability. You can try out our version or wait for SQLite 3.7 and see if it does something similar.
http://download.oracle.com/berkeley-db/db-5.0.26.tar.gz :) -greg @gregburd and @berkeleydb on Twitter, Product Manager for Berkeley DB at Oracle (so I'm a tad biased...) > -----Original Message----- > From: Simon Slavin [mailto:slav...@bigfraud.org] > Sent: Friday, July 02, 2010 1:46 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Multithreading support approach > > > On 2 Jul 2010, at 6:14pm, Cargnelutti, Pablo Fernando wrote: > > > Sqlite implements table level lock? > > No. SQLite locks the entire database file with all tables and views in > it. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
