MobileRead Forums - View Single Post - Are too many single-use tags (in tags-like field(s)) bad for Calibre's performance?

01100001 · 09-19-2022, 09:53 AM

Hello all, again!

I'm using a custom column called Filenames (#filenames) of type Comma separared text, like tags, shown in the Tag browser.

What this is means is that as I add more and more books, there will be a ton of single-use tags in this custom column/field. (And by single-use tags I mean, that all tags will be used just once, besides there may be multiple per book, so they'll add up pretty quickly.)

Question: Since calibre offers to auto-fill these fields, apart from showing the whole lot in the Item editor and the Tag browser (where I disabled the category), I would like to know if this will be a problem for Calibre's performance in the long-term.

I also ask because, for another library/project I intend to import a huge database (via CSV format) of hundreds of thousands of books. But this is also a concern for my personal library (5k books).

Why do I use a tags-like field for filenames?

I believe I explained it in good detail here.

09-19-2022, 09:53 AM	#1
01100001 Enthusiast Posts: 33 Karma: 10 Join Date: Sep 2022 Device: Microsoft Surface Pro 7, Apple iPad	Are too many single-use tags (in tags-like field(s)) bad for Calibre's performance? Hello all, again! I'm using a custom column called Filenames (#filenames) of type Comma separared text, like tags, shown in the Tag browser. What this is means is that as I add more and more books, there will be a ton of single-use tags in this custom column/field. (And by single-use tags I mean, that all tags will be used just once, besides there may be multiple per book, so they'll add up pretty quickly.) Question: Since calibre offers to auto-fill these fields, apart from showing the whole lot in the Item editor and the Tag browser (where I disabled the category), I would like to know if this will be a problem for Calibre's performance in the long-term. I also ask because, for another library/project I intend to import a huge database (via CSV format) of hundreds of thousands of books. But this is also a concern for my personal library (5k books). Why do I use a tags-like field for filenames? I believe I explained it in good detail here. Last edited by 01100001; 09-19-2022 at 10:01 AM.