> So if I want to perform a query with the connection with the 2 db attached > does the query will search data to the shared cache to have the fresh data ?
Yes, this 3rd connection will use the same cache as 1st connection for db1 data and the same cache as 2nd connection for db2 data. Pavel On Tue, Nov 24, 2009 at 10:07 AM, presta <harc...@gmail.com> wrote: > > In fact I want to work on 2 different database. > > 1 connection (cx1) with the db1 for write operations (shared cache enabled, > read uncommited) > 1 connection (cx2) with the db2 for write operations (shared cache enabled, > read uncommited) > > And another connection (or cx1) with both db1 and db2 attached to make > select query with tables join. > > insertions via cx1 & cx2 use a big transaction for performance issue... > > So if I want to perform a query with the connection with the 2 db attached > does the query will search data to the shared cache to have the fresh data ? > > > > >>What difference does it make for you? What do you call "shared cache" >>here? Two different files cannot share cache anyway because they're >>different files with different pages. Or do you call caches shared if >>they can use the same memory? Then cache in SQLite is always shared. >>Or do you ask whether SQLite will use the same internal class and >>share cache limits for both files? Then the answer is no, it won't. > >>Please elaborate what exactly do you want to know. > >>Pavel > > > -- > View this message in context: > http://old.nabble.com/ATTACH---Shared-cache-tp26496094p26497496.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > 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
