Hi Everyone,
We are seeing the following strange behaviour with SQLite. Our environment is as follows 1. SQLite 3.5.3 2. Using MEMORY DB 3. Many databases 4. Sun Solaris machine T2000 (32 cores and 16G memory) 5. A single DB table with only 2 entries (so size is not an issue here!) 6. A production - NOT a debug version of the library. TEST 1 A single process. We continually hammer the database with the same query. We find a row entry in an average of 3ms. The max response time is approx. 4ms to 5ms. TEST 2 We run 8 processes (each has its own DB). The average response time on ALL of the databases increases to 5ms However the max reponse time has increased to 30ms to 40ms. It appears that some resource is being shared between the processes. Can anyone advise us on what resources could be shared and how the problem could be avoided. Any help would be gratefully appreciated -- View this message in context: http://www.nabble.com/Running-multiple-SQLite-processes-tp14320370p14320370.html Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
