On 5 Oct 2017, at 12:07am, Toby Dickenson <[email protected]> wrote:
> How does PRAGMA optimize or ANALYSE affect concurrency? Is there any > risk that it might leave the database locked for the full duration of > the scan? ANALYZE does this every time. It’s not possible to analyze a database while it’s being changed. I’d expect "PRAGMA optimize" to do the same but I’m not sure. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
