Hello,
I am currently using the SQLite Amalgamation v3.6.19 from http://www.sqlite.org/download.html in an ISAPI Extension to write out usage statistics to an SQLite database. When the ISAPI extension is running inside an Application Pool with a single worker process, everything works fine. However, when it is run inside an Application Pool with multiple worker processes, the database soon becomes locked and cannot be written to by any of the worker processes. Each worker process has a separate background thread which writes to the database every 5 seconds. Each write is performed as a single transaction starting with "BEGIN IMMEDIATE". Any help you can provide would be greatly appreciated. Thanks, David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
