On 5 Oct 2017, at 12:07am, Toby Dickenson <t...@tarind.com> 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.

sqlite-users mailing list

Reply via email to