Re: [sqlite] Multithreading support approach
Thanks Greg I will check your version :) Pablo -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Greg Burd Sent: Friday, July 02, 2010 3:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Multithreading support approach 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Multithreading support approach
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
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] Multithreading support approach
Hi all, I'm a beginner user of this tool. I have to questions. What would be the better approach to multithread support for sqlite using C++ API? I'm currently try to block, using boost mutex, locks and condition variables, all calls to step method that attempts to modify the DB. Sqlite implements table level lock? Regards Pablo ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
