If you make a lot of metadata changes via various plugins, you will see that the metadata.db file will grow enormously due to unclaimed SQLite database space.
Real example statistics from a SQLite browsing tool that does a compress:
Before compacting<<<----------->>>After compacting:
Page Count = 118,342<<<---------->>>Page Count = 3,606
Database Size = 121,182,208 bytes<<>>Database Size = 3,692,544 bytes
So, the metadata.db file went from over 121mb to less than 4mb in size.
If you have many Libraries, and if you use Job Spy, there is a menu option under "Utilities" named "Vacuum/Compress metadata.db [All Other Libraries]". It vacuums all except the current Library which is open in Calibre at the moment. Libraries must be "closed" to be vacuumed.
Remember to make periodic full backups of all of your Libraries, and also before doing anything en-masse.
DaltonST
|