--- John Stanton <[EMAIL PROTECTED]> wrote: > Using a single Sqlite connection for each database and holding the > connection open means that maximum effect is obtained from Sqlite's > cache. As far as we can ascertain avoiding fcntl removes any issues > regarding multiple threads accessing a single connection.
I did not know that a single sqlite3 connection could be used concurrently by readers from multiple threads. Previous postings on this list suggested that although an sqlite3 connection could be passed from thread to thread (as is common in a connection pool scenario), only one thread may use that connection at a given time. Can the SQLite authors confirm that simultaneous use of a single connection by multiple reader threads is supported without external mutexes? ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
