Hi there, I want to see if there is anyone using sqlite-3.3.3 with perl-DBD-SQLite in a mod_perl environment where multiple threads will be present.
The FAQ indicates the default sqlite3 does not have multi-threading option enabled. But I want to stick with the system library as much as possible. I am thinking to remedy the issue by doing a file lock (i.e. flock) before calling the INSERTs. This will hurt performance a bit but at least it will not corrupt the database, which we have seen it happening a lot under load. Any comments?? thanks ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
