I'm new to this list and I didn't see this question answered in the places I looked. We have a system that uses a handful of commands to read and write to an SQLITE database. We already control the commands so that only 1 thread in one process writes to the database file at any point in time. However, there may be multiple READS attempting to access the same database. My question is this. Can I simply change the SQLITE code so that the fcntl() call for a read lock does a BLOCKING wait instead of a non-blocking wait ? I don't care if the commands take longer to run, but I just don't want to cause a deadlock. Has anybody tried this ? What about changing the fcntl() for both reads and writes to a BLOCKING wait ? Any help would be appreciated. We are currently getting too many "busy" failures when reads are attempted.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
