Calibre Very Slow
Calibre was extemely slow and since I only have 5800 books, this seemed odd. I found the metadata.db file was 2GB in size. Finding this a ridiculous size for so few books, I poured over the file structure. I found 52 metadata.opf files that were over 1MB in size and some as large as 250MB. I either could edit the metadata for the book (I found some insanely large comments that needed to be shortened) within Calibre and it saved much smaller (less than 16KB), or I had to delete three books (the one I needed to be deleted would freeze Calibre unless it was sandwiched between two good books) and reimport them. Many hours later and Calibre works as it did before. The metadata.db file is now less than 15MB, significantly smaller than 2GB. Most of the large file sizes occurred on January 31, 2020 but the books were purchased many years prior. I'm not sure it's a bug but something happened on that date and I did not have any computer problems at that time nor do I recall Calibre doing anything odd.
I'm posting this in case others are struggling with Calibre being slow.
|