Quote:
Originally Posted by BetterRed
Relational databases accumulate dross over time, mainly due to deletions and replacements, so they need to be optimised occasionally - aka as 'vacuuming' Ψ²
By rebuilding it you have eliminated the dross. FYI - the Check database function does a 'vacuum' as its first step.
BR
|
I agree with all you said. But...
not the 4 times bigger part.
Everything (in the defining tables) would have to have been redefined, many times to get that huge.
I DO recommend 'quarterly' housekeeping (Calibre Maintenance) on any Library with frequent Metadata defining changes. FWIW in a RDB you define an Author: J.D. Robb. You assign that defined author INDEX (not visible to a normal user) to a book entry. , The same is true for all column types except Comments. That is a BLOB.