Quote:
Originally Posted by theducks
the 'Data' table grows a record for each format, the 'Formats' Index grows.
These are both small (record wise), so you would need a pretty huge library to seriously impact day-to-day performance (there are some tasks that will see a jump in time. These are not done regularly.)
|
Hmmm. Depends on which tasks. I'd assume initial calibre startup when loading the DB. And any display tasks for the booklist that involve my custom column
#formats which is based on
format.
Here are some I know from experience: externally copying entire library for backup purposes at system level. Saving out formats for large number of records. Searching
format:PDF is significantly faster than searching
#formats:PDF, on the order of 50x to 100x. Any searches that iterate through the default field
format have to take longer with multiple formats, but even at 2x or 4x the number of formats per record it would probably require less than a second per each subset of 10K books, on my MacBookPro 2.2 GHz Intel i7 quadcore.
There are probably other affected tasks I've missed remembering or knowing about.