MobileRead Forums - View Single Post - Vast rewrites when importing a wrongly cased author

BetterRed · 01-22-2018, 03:46 PM

@Scirius - On my Win 10 system the OPF writes occur at about 1/sec, with little effect on calibre or general performance. That's been true on 3 different computers running Windows and Mint since I first installed calibre (0.8.??) in early 2012.

The only settings I can think that might, and its a pretty big might, have a bearing on the issue are

the Maximum [. . .] jobs and the Limit [. . .] jobs [. . .] settings in Preferences->Miscellaneous -- mine are 1 and unchecked;
the Job Priority setting in Preferences->Miscellaneous -- mine is Low.

My 'gripe' with this issue is not the writing of them but the fact they then have to be copied by my incremental backups, which not only slows it down, but makes eyeball checks of the backup logs harder (wood for trees). But I don't have a alternative solution to database rebuilding - apart from mirroring the database. And the OPF files are used for other purposes so... I think we're stuck with it

In my backup scripts, I have a set of calibredb backup_metadata commands to flush any pending OPF writes before the actual backup task is started.

BR

01-22-2018, 03:46 PM	#7
BetterRed null operator (he/him) Posts: 21,778 Karma: 30237628 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Scirius - On my Win 10 system the OPF writes occur at about 1/sec, with little effect on calibre or general performance. That's been true on 3 different computers running Windows and Mint since I first installed calibre (0.8.??) in early 2012. The only settings I can think that might, and its a pretty big might, have a bearing on the issue are the Maximum [. . .] jobs and the Limit [. . .] jobs [. . .] settings in Preferences->Miscellaneous -- mine are 1 and unchecked; the Job Priority setting in Preferences->Miscellaneous -- mine is Low. My 'gripe' with this issue is not the writing of them but the fact they then have to be copied by my incremental backups, which not only slows it down, but makes eyeball checks of the backup logs harder (wood for trees). But I don't have a alternative solution to database rebuilding - apart from mirroring the database. And the OPF files are used for other purposes so... I think we're stuck with it In my backup scripts, I have a set of calibredb backup_metadata commands to flush any pending OPF writes before the actual backup task is started. BR