Is there any rationale for (not) running incremental_vacuum in an transaction?
Unlike a full VACUUM, it seems to work with or without. Purpose: We are running with auto_vacuum = INCREMENTAL, and when closing the file in our software, we do an on-demand cleanup like so: if (Query('pragma freelist_count') > threshold) while (time_passed < max_time) Exec('pragma incremental_vacuum(1)'); In practcie, the condition involves more than a single query, and we will elevate that from silent to "with UI" if there's a lot to be reclaimed. A quick (statistically insigificant) test suggests that we do make more progress within an transaction, OTOH it feels "strange". -- View this message in context: http://sqlite.1065341.n5.nabble.com/incremental-vacuum-within-or-outside-transaction-tp70086.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users