Hi everyone
Currently, I am using SOCI checked out on 23rd of March 2010. Furthermore,
my sqlite version is 3.6.23.1. While this combination works as expected with
a single thread, in multi-threaded mode, the program performs incredibly
slow. The database access is correct and the results are as expected, but as
soon as there exist multiple connections to the database, the execution is
incredibly slowed down (even slower than when executed sequentially by using
additional semaphores to guard the DAO access). Compiling sqlite3 with
different SQLITE_THREADSAFE flags does not affect this behavior, nor does
creating the SQL session object with different connection strings
("mode=read threads=multi"). In fact not even whether or not I start a
transaction does draw a distinction in this case.
The program runs on an embedded MOXA UC-8410 device. Other threaded tasks
perform as expected. My question is thus: Where could this performance lack
originate from? Are there some file-level locks that prevent efficient
access or do I need to compile the libraries with different flags to achieve
a decent result here?
Thanks for any suggestions and best regards
Pascal
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
