On Tue, Jan 14, 2014 at 5:15 PM, Tilsley, Jerry M. < jerry.tils...@st-claire.org> wrote:
> All, > > I have a database that I am using with a couple processes that will modify > the database at near the same time. So I thought this would be the ideal > time to investigate the WAL mode. How do I enable this on the database, Run "PRAGMA journal_mode=WAL;" just once on the database file. This can be done using the command-line shell, completely outside of our program. > and what do I need to watch for when talking to this db after WAL mode is > enabled? > If there is never a time when there are no processes reading from the database, then the WAL file itself might grow without bound. The "checkpoint" operation needs to catch the database at a moment when nobody is reading in order to truncate and reset the "-wal" file. > > Thanks! > > Jerry Tilsley, CIS Lvl 2 > St. Claire Regional Medical Center > Sr Systems Analyst > jerry.tils...@st-claire.org > > ________________________________ > > Disclaimer**** > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of St. > Claire Regional Medical Center. If you are not the intended recipient, be > advised that you have received this email in error and that any use, > dissemination, forwarding, printing or copying of the email is strictly > prohibited. If you received this email in error please notify the St. > Claire Regional Helpdesk by telephone at 606-783-6565. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
