Quote:
Originally Posted by kiwidude
Not particularly slow, no. Doing a hundred books takes less than five seconds to update the database with the results on my machine. The updating is mostly using the same Calibre code as downloading metadata does.
|
Be sure to use commit=False when updating the column, then commit at the end. If you don't, then SQLite will *per change* create, write, read, and delete a journal file. This can easily take a second, and is much worse on a NAS.
When we added commit-at-end to bulk metadata edit, changes to a column for 500 or books went from many minutes to a few seconds.