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

Reply via email to