View Single Post
Old 07-05-2020, 01:47 PM   #5
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,119
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by droopy View Post
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
theducks is offline   Reply With Quote