MobileRead Forums - View Single Post

ownedbycats · 12-09-2022, 04:30 PM

I was having a look at the index database to see if there was some way to take account of books that have no indexed text (dummy files, or non-OCR'd pdf scans).

The books_text table in the index database shows 5554 entries to my 6,462 book records. 842 boook entries have only dummy paperback/overdrive files, so it seems to roughly match up (taking into account a) unknown number of PDF scans and b) book records with multiple formats).

I don't want to run another full re-index, but I'm curious whether 5554 matches the number Calibre would report when doing that.

Alas, not sure what I can do. I have the ids of all the books indexed, so theoretically I could look for the missing numbers. But the gaps from deleted books...

12-09-2022, 04:30 PM	#14
ownedbycats Custom User Title Posts: 11,115 Karma: 77213681 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I was having a look at the index database to see if there was some way to take account of books that have no indexed text (dummy files, or non-OCR'd pdf scans). The books_text table in the index database shows 5554 entries to my 6,462 book records. 842 boook entries have only dummy paperback/overdrive files, so it seems to roughly match up (taking into account a) unknown number of PDF scans and b) book records with multiple formats). I don't want to run another full re-index, but I'm curious whether 5554 matches the number Calibre would report when doing that. Alas, not sure what I can do. I have the ids of all the books indexed, so theoretically I could look for the missing numbers. But the gaps from deleted books... Last edited by ownedbycats; 12-09-2022 at 04:33 PM.