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
