hus a COMMIT can happen without ever writing to the original database, which allows readers to continue operating from the original unaltered database while changes are simultaneously being committed into the WAL. Multiple transactions can be appended to the end of a single WAL file. =========== But WAL-mode database must be handled by a single DLL - thus network etc writing to DB from remote clients is highly discouraged. It means multiple access via a single dispatcher - remember my asking about MSEIFI for these purposes.
2012/1/18, Martin Schreiber <mse00...@gmail.com>: > On Wednesday, 18. January 2012 00.04:42 Christian Nobel wrote: >> Hi. >> >> Do any of you have knowledge of how to use the WAL mode of SQLite3 with >> FPC (as I understand this should open up for some concurrency)? >> > http://www.sqlite.org/draft/wal.html > " > How WAL Works > The traditional rollback journal works by writing a copy of the original > unchanged database content into a separate rollback journal file and then > writing changes directly into the database file. In the event of a crash or > ROLLBACK, the original content contained in the rollback journal is played > back into the database file to revert the database file to its original > state. The COMMIT occurs when the rollback journal is deleted. > The WAL approach inverts this. The original content is preserved in the > database file and the changes are appended into a separate WAL file. A > COMMIT > occurs when a special record indicating a commit is appended to the WAL. > Thus > a COMMIT can happen without ever writing to the original database, which > allows readers to continue operating from the original unaltered database > while changes are simultaneously being committed into the WAL. Multiple > transactions can be appended to the end of a single WAL file. > " > Looks as a Sqlite internal thingy to me. > > Martin > > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > mseide-msegui-talk mailing list > mseide-msegui-talk@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk > ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ mseide-msegui-talk mailing list mseide-msegui-talk@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mseide-msegui-talk
