Re: [sqlite] Threads and locking

Thanks again, -- BP << www.planet-hood.com >> Welcome to our world << -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, December 16, 2005 1:07 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Threads and locking Have you thought

RE: [sqlite] Threads and locking

I used to have the same issue. I finally did two things: 1. The background worker thread is at least normal priority. If you own the DB, you need to get in and get out. I put sleeps in to make sure I wasn't hitting the DB too often from this thread 2. All connections to the database happen

RE: [sqlite] Threads and locking

<< www.planet-hood.com >> Welcome to our world << > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, December 16, 2005 1:07 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Threads and locking > > Have you though

Re: [sqlite] Threads and locking

Have you thought of using a lock to synchronise access to the databaseso that only one thread at a time could change the database although both could read simultaneously? JS Barry Paul wrote: Hi, I am having some unexpected locking issues with SQLite. I have a desktop application that uses