Thread: Causes for library updates to be slow
View Single Post
Old 12-22-2020, 07:15 PM   #2
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 11,000
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
metadata.db-journal is a rollback journal for sqlite. If something goes wrong mid-change (e.g. power interuption - FAT32 filesystems were known for corrupting after them) it can restore and prevents things from breaking. It deletes itself when done.

Could be a number of things causing slowness. Overly complex composite columns needing to be calculated, a database that hasn't been vacuumed in a while, the drive being stored on a slow (or failing) hard drive.
Last edited by ownedbycats; 12-22-2020 at 07:24 PM.
ownedbycats is offline   Reply With Quote