Quote:
Originally Posted by droopy
Until I read this post, I had no idea about the vacuuming databases.
Should everybody be vacuuming their databases?
I have just one Calibre library
|
The reason is Dust Bunnies

This is bloat from deleted records. The highest {ID} vs # of books (shown on the status bar) is a clue if the range has
jumped a lot since the last cleaning. (Changing most anything will cause some dust. It just depends where. Understanding a bit about Relational DB's is needed. Adding a book to from an existing Author, makes no change to the Author table. It just uses the key# it was assigned for the new title. Changing (correcting) that name for the new book, WILL leave dust (was 2 Authors records, now back to 1)
For this kind of reason, having an 'Intake Library' for the dirty work of data cleaning before using '
Copy to Library:Main' , keeps the dirt down
In most cases, if your Library is
smallish or Authors - Titles are stable, it probably does not need to be done
The deleted records are really marked inactive until housekeeping tosses the trash
Note that a side effect is the Last_Modified gets bumped. For the Library