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. I thought it might be because a checkpoint was not being reached, so i made the writer proccess do a sqlite3_wal_checkpoint_v2(sqcache_conn, NULL, SQLITE_CHECKPOINT_FULL, &a, &b); when it is done updating, to no result. But connecting with the sqlite3 shell shows the changes in the db as they happen. What am i doing wrong? Thanks a lot in advance. Alejandro _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
