On 12 Aug 2010, at 12:09pm, Yoni Londner wrote: > I would like to know how can I find out how many dirty pages are on wal > cache after an update query (during a transaction). > My intention is to run a long transaction, and to end it when cache/wal file > is getting too large.
Sorry, but the two figures are not the same. If you want to know how big the WAL file is, just use normal file calls to find out how big it is, don't try to do it from something inside SQLite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users