hi, I did some tests with the in-memory database and didn't find any way to use the in-memory database from multiple db handles in the same process. Having this capability would enable a multithreaded application to have e.g. multiple read transactions (each with its own db handle) to run in parallel.
As far as I could see this is not possible. Correct? The implementation in function sqlite3BtreeOpen() seems to ignore any setting of sqlite3SharedCacheEnabled() if it is a in-memory database. What about having in-memory databases named like: ":memory:<dbname>". So as to be able to indicate to sqlite3_open_v2() to create multiple in-memory db handlers sharing the same btree. What do you think? Markus <img src="http://www.bigstring.com/refer.php?img=60" width="1" height="1">BigString.com, a smarter way to email. Signup for a free email account today. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users