Ok, i will probably do that. Thank you. But i'd like to know. Why doesn't this work without wal? A read only operation shouldn't block, right?
And regarding the commit failing, does that need a busy timeout handler too? From documentation i though it would just wait until all readers are done reading and then write. And that further incoming readers would wait for those 5 seconds. And i was expecting not to really wait, as the commit should be pretty quick, right? I'm puzzled. On Wed, Nov 28, 2012 at 10:01 AM, Richard Hipp <d...@sqlite.org> wrote: > On Wed, Nov 28, 2012 at 6:56 AM, Alejandro Martínez <elpeq...@gmail.com > >wrote: > > > Is that the only way? > > > > When i had done that in the past, the wal file grew constantly and i am > > afraid it could fill the hard disk. > > > > That could happen if say... one of the reading processes doesn't > > properly sqlite3_reset a prepared statement after stepping it. right? > > > > Correct. The WAL file will grow until a checkpoint resets it. And a > checkpoint cannot reset the WAL file while there is a pending transaction. > So if you have a statement holding a transaction open, the WAL file will > grow without bound. > > The solution there is to not hold read transactions open indefinitely. > Call sqlite3_reset() when you are done with a statement so that its implied > read transaction will close. > > > > > > Thank you for your quick answer. > > > > > > > > On Wed, Nov 28, 2012 at 9:52 AM, Richard Hipp <d...@sqlite.org> wrote: > > > > > PRAGMA journal_mode=WAL > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
