Library.db size more than doubled in latest version

[evil_hero]

Library.db size more than doubled in latest version

My db had over 1b lines to remove, so the delete from statement took ages. I turned it around and created a temporary table containing only the wanted data, deleted the original table and renamed the temp table: – Create a new table without the unwanted rows CREATE TABLE statistics_bandwidth_new AS SELECT * FROM statistics_bandwidth WHERE account_id IS NOT NULL; – Drop the old bloated table DROP TABLE statistics_bandwidth; – Rename the new compacted table ALTER TABLE statistics_bandwidth…

These ones.
You copy the non null values to a temp table, then drop the bloated table and rename the temp table.

Or just try the delete and vacuum like you were doing. I dunno I just know mine would do the same thing, move quickly, come to a halt and just hang.

So I rebooted and then did those steps above, but delete and vacuum might work as well.