> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Philip Nick > Sent: Thursday, January 17, 2008 1:48 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] sqlite3 performace > > Greetings, > > Currently I am using sqlite3 in a multi-process/multi-threaded server > setting. > I use a Mutex to ensure only one process/thread can access the database at > one time. > > The current flow of events: > Get Mutex > Open Database connection > Run Query > Close Database connection > Release Mutex > > This seems to work well except I have noticed some performance issue when > the database grows beyond a MB.
Why not move the Open/Close outside of the mutex, hold a connection open, and re-use it for all queries? Otherwise you're making SQLite reload the schema definition every time you perform a query, as I understand it. -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------