[repost after initial e-mail was mangled up with HTML/XML tags]
hi,
Just to let you know. I did some more tests and skimmed through the source
code. Here a quick description of how the reloading from disk works in a
multithreaded process:
(1)
If shared cache is disabled, each call to sqlite3_open() will result in a db
handle with its own btree and page cache. If the page cache is not shared, each
db handle needs to refresh its page cache from disk if some other thread or
process using some other db handle has written to the database. The magic piece
of code is in pager.c: pagerSharedLock().
if( memcmp(pPager->dbFileVers, dbFileVers, sizeof(dbFileVers))!=0 ){
pager_reset(pPager);
}
If the version number read from the file on disk is different than the version
number in memory, reset the pager cache.
(2)
If shared cache is enabled, and it's a disk-based database (not in-memory, not
temporary) each call to sqlite3_open() results in a db handle that points to
the same shared btree and page cache (the relevant code can be seen in the
implementation of sqlite3BtreeOpen() ). This also means if there's a write
transaction from any of the db handles, the page cache version number is
increased. This eventually leads to the fact the version number on disk and
version number in the page cache are the same. I.e. no reload happens.
Hope that helps bit.
Markus
PS: Below some sample code I used. Simply compile and run with "sampleapp
db-file". Note that it deletes the file first if it exists. Run the
application with e.g. "strace -f" (Linux distro) to see system calls. The
application creates two db handles to the same db (one in the main thread and
one in a newly started thread). The first one only writes and the second one
only reads.
#include
#include
#include
#include
#include
/*
* Sample code. No guarantees for correctness
*/
/*
* some global variables that are quick'n'dirty but do the job
*/
char** argv_global;
/*
* A callback function needed for sqlite3_exec. Copied from sample code.
*/
static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
for(i=0; i
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces.
It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
