VACUUM when pruning DB
authorIan Beckwith <ianb@erislabs.net>
Thu, 7 Oct 2010 19:02:27 +0000 (20:02 +0100)
committerIan Beckwith <ianb@erislabs.net>
Thu, 7 Oct 2010 19:02:27 +0000 (20:02 +0100)
lib/ID3FS/DB.pm

index 11429ac..9369fbf 100644 (file)
@@ -812,6 +812,7 @@ sub remove_unused
        LEFT JOIN files_x_tags ON files_x_tags.tags_id=tags.id
        WHERE files_x_tags.files_id IS NULL);
 
+    VACUUM
 EOT
     print "SQL: $sql\n";
     my @sql=split(/\n\n/, $sql);