Thread: Any rule of thumb of how often to vacuum the database via Check Library?
View Single Post
Old 07-06-2020, 11:08 PM   #18
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by droopy View Post
Dalton's page count was reduced to 1/40th of its original size and db size reduced to 1/33th. How does this affect Calibre performance?
It should only affect performance when starting calibre or when any database writes are done. Most of the latter will probably not be noticed as they are done in the background. Closing calibre might take longer as any database updates not already done have to be done.

Looking at the databases for my libraries, I suspect that @DaltonST's are an anomaly. The biggest is 16MB, and it's size changed by less than 1MB when I vacuumed it. The others are smaller and the change was similar. But, how much is needed depends on how many changes you are making. For those using an intake database, where books are added and removed constantly, it is probably more noticeable. For anyone adding one book a day, fixing the metadata and making no more changes, it probably isn't noticeable.
Quote:
What are the side effects of never vacuuming?


Kovid, do you think "vacuuming" should be automatically done by Calibre?
I ask for 2 reasons:
1. I don't want any changes to modification date
2. If it's beneficial, it's good for it to be automatic
I don't see any changes to the book modification date. @theducks said something about it, but, the post seems to be incomplete. I think he meant when moving the book between libraries.
davidfor is offline   Reply With Quote