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 interface, so I might not gives things the proper SQLite terminology) which does a lot of querying (that might take some minutes), but every now and then does some updates and commits within a few seconds of the updates. Assuming that another one of these processes starts up after the first one is running: - Can the second one query while the first one is querying? - Can the second one query while the first one is updating? - Can the second one update while the first one is updating? - does committing in the first one release the lock and allow the seocnd one to continue? -- Paul Tomblin <[EMAIL PROTECTED]> http://xcski.com/blogs/pt/ Today while watching people complain about the latest Windows worm outbreak, I likened Windows users to people stuck in abusive relationships: they get beat up over and over again, but they won't leave. -- Steve VanDevender
