Re: [sqlite] Multi-threading problem!

2009-01-28 Thread Ken
Create a connection for each thread. --- On Wed, 1/28/09, Anatoly Stepanov wrote: > From: Anatoly Stepanov > Subject: [sqlite] Multi-threading problem! > To: "sqlite-users@sqlite.org" > Date: Wednesday, January 28, 2009, 7:58 AM > Hello! > I use the latest (3.6.1

[sqlite] Multi-threading problem!

2009-01-28 Thread Anatoly Stepanov
Hello! I use the latest (3.6.10) version of SQLite library. I was trying to perform query "select" from one table inside single database connection from different threads(up to 8 threads). In summary I had 50% CPU Usage( 2 core CPU)-this is a problem! I tried to find the reason in Debug mode and