I get this ... from sqlite error log callback Sqlite3 Err: (283) recovered 6942 frames from WAL file C:\eQube-Tools\flashboard\server\option.db-wal
pretty much every time I restart the program now (espcially if it segfaults). There are no frames to recover... really... I mean it should have recovered them any of the previous 10 times, no? I'm pretty sure that I'm not even doing a modification now; previously I was possibly updating a table's value to the same value. If my program segfaults I don't get a chance to graceful close all outstanding statements and connections; so the -wal and -shm file's are never deleted. I can understand keeping them open; but when they're done; can't you at least; I dunno truncate them? in my VFS that's not a very expensive operation... other than of course re-expanding when you need the space; but at least you're not doing a directory search to get a handle to it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
