[sqlite] Question about locking

2010-01-27 Thread yava
Sqlite uses file locking for concurent access to databases. Is it possible to implement locking using data synchronization library liburcu (http://lttng.org/?q=node/18) on top of mmaped file? I'm sure this would be not sqlite but some other light database. RCU achieves scalability improvements by

Re: [sqlite] Question about locking

2006-01-26 Thread drh
Paul Tomblin <[EMAIL PROTECTED]> wrote: > I'm curious about the duration of locks, specifically when other processes > can get in to do their bit, since SQLite is so different from other > RDBMSes that I've used (Oracle, Sybase, PostgreSQL, MySQL). > > If I have a process that opens a database wit

[sqlite] Question about locking

2006-01-26 Thread Paul Tomblin
I'm curious about the duration of locks, specifically when other processes can get in to do their bit, since SQLite is so different from other RDBMSes that I've used (Oracle, Sybase, PostgreSQL, MySQL). If I have a process that opens a database with autocommit turned off (I'm talking the perl DBI