Hi, thanks for the response. I'm still unclear though. Can you please clarify what the xShm* VFS operations are supposed to do: xShmMap, xShmLock and SQLITE_SHM_NLOCK, xShmBarrier and xShmUnmap.
I'd suppose Sqlite uses the latter three as functional equivalent to mutexes to guarantee state/data consistency in parallell access to the mapped memory? And furthermore, by shared memory in this scope, do we mean a memory allocation that is shared between apps (without a mirror on disk), or, do we mean a disk file where the OS provides a conveniency wrapper for fread and fwrite such that the app can now do this by accessing a particular interval or memory addresses instead. In all cases, does Sqlite access the shared memory file via direct RAM access (e.g. mov [address],ax) or via fread/fwrite? If I remember right, previously on the ML, a person said that a WAL database could be opened by several nodes on a networked filesystem simultaneously. I'd like to be able to understand if this is correct or not - need to understand what the xShm* and foundation for the mapping as per above is for this though. Thanks and kind regards, Mikael 2012/1/29 Roger Binns <rog...@rogerbinns.com> > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 28/01/12 02:17, Mikael wrote: > > I have a hard time getting a clue of how exactly sqlite uses them, > > WAL is well documented at: > > http://www.sqlite.org/wal.html > > The latest major section talks about shared memory and the wal-index. It > also includes a link to more details about the wal-index which points here: > > http://www.sqlite.org/fileformat2.html#walindexformat > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAk8km4EACgkQmOOfHg372QSKVQCgn3p/I1acLmBCScAItsUnSaEB > V/4AoMsDQfEgtJKP4eHYVtXzgO+bezj5 > =EZ52 > -----END PGP SIGNATURE----- > _______________________________________________ > 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