On 11/28/2011 12:10 PM, Alejandro Martínez wrote:
I'd appreciate some direction on how to make this work.
I have one process that writes on a database. It "realoads" tables by
filling a new table and then replacing the old one via a drop and a
rename within a transaction.
Then there are several processes that just read from this database.
I don't want these "readers" to block, so i made the database "wal".
The thing is, it seems this "readers" don't ever see any changes in
the db unless i shut them down and run them again.
You keep a transaction open on the reader connection, either explicitly
by issuing a BEGIN without a matching END, or by stepping a statement
and then never resetting or finalizing it. Don't do that.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
