Re: [sqlite] Multi-threading problem!

[Ken]

Create a connection for each thread.



--- On Wed, 1/28/09, Anatoly Stepanov <anatoly.stepa...@kaspersky.com> wrote:

> From: Anatoly Stepanov <anatoly.stepa...@kaspersky.com>
> Subject: [sqlite] Multi-threading problem!
> To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org>
> Date: Wednesday, January 28, 2009, 7:58 AM
> 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
> I've found that the most of the execution time one
> thread was executing when  other threads waited him..
> So I have at least two questions:
> 1.What may be a reason for this lack of performance?
> 2.May be I there is  a RIGHT way for multi-thread using of
> SQLite?
> 
> 
> Best regards!
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Multi-threading problem!

[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 I've found that the most of the execution time one 
thread was executing when  other threads waited him..
So I have at least two questions:
1.What may be a reason for this lack of performance?
2.May be I there is  a RIGHT way for multi-thread using of SQLite?


Best regards!


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users