MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Remove books from fulltext index?

Notices

Reply
 
Thread Tools Search this Thread
Old 12-28-2024, 04:49 PM   #1
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 262
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Question Remove books from fulltext index?
How do I remove books from the fulltext index?

I have some very large books that I don't want included in fulltext searching, because they slow it down.
Geremia is offline   Reply With Quote
Old 12-28-2024, 04:56 PM   #2
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 11,360
Karma: 79528341
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Remove the book's formats and add it to the extra data folder.
ownedbycats is offline   Reply With Quote
Old 12-28-2024, 05:08 PM   #3
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 262
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Quote:
Originally Posted by ownedbycats View Post
Remove the book's formats and add it to the extra data folder.
That's a good hack, but is there a non-kludgy way of doing it, such as with calibredb or something?
Perhaps I could simply edit the full-text-search.db in sqlitebrowser.
Geremia is offline   Reply With Quote
Old 12-28-2024, 05:56 PM   #4
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 22,018
Karma: 30277294
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by Geremia View Post
How do I remove books from the fulltext index?

I have some very large books that I don't want included in fulltext searching, because they slow it down.
Surely once a book is indexed its size shouldn't have any impact on performance, unless you rebuild the index. And if you're doing that… why and how often? The indexing of new books is supposed to happen automagically when they're added.

That said, you could move the books in question to another library which doesn't have full text search enabled.

BR
BetterRed is online now   Reply With Quote
Old 12-28-2024, 11:25 PM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,609
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Size of a book doesnt affect search performnce, only indexing performance and indexing is one time. If you dont want some books indexed the best way to do it is keep them in a separate library where you havent turned on indexing.
kovidgoyal is offline   Reply With Quote
Old 12-29-2024, 12:46 AM   #6
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 262
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Quote:
Originally Posted by BetterRed View Post
once a book is indexed its size shouldn't have any impact on performance
It does for me. When I search for a term and it gets to these huge files, it takes a long time to display the excerpt.
Geremia is offline   Reply With Quote
Old 12-29-2024, 01:05 AM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,609
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Quote:
Originally Posted by Geremia View Post
It does for me. When I search for a term and it gets to these huge files, it takes a long time to display the excerpt.
Yes displaying excerpts will be slow, but actually finding matches will not. Excerprts arent indexed they have to be searched for in the book text.
kovidgoyal is offline   Reply With Quote
Old 12-29-2024, 07:11 PM   #8
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 262
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Quote:
Originally Posted by kovidgoyal View Post
Yes displaying excerpts will be slow, but actually finding matches will not. Excerprts arent indexed they have to be searched for in the book text.
Is there a way to disable displaying excerpts?
Geremia is offline   Reply With Quote
Old 12-29-2024, 08:13 PM   #9
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,609
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Quote:
Originally Posted by Geremia View Post
Is there a way to disable displaying excerpts?
No, to do that you would need to write your own SQL queries against the full text db.
kovidgoyal is offline   Reply With Quote
Old 12-31-2024, 01:55 PM   #10
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 262
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Quote:
Originally Posted by kovidgoyal View Post
No, to do that you would need to write your own SQL queries against the full text db.
What's the exact SQL query that CalibreDB runs on full-text-search.db?
Geremia is offline   Reply With Quote
Old 12-31-2024, 08:04 PM   #11
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,609
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
See the search function in fts_connect.py
kovidgoyal is offline   Reply With Quote
Old 01-01-2025, 07:33 PM   #12
Geremia
Addict
Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!Geremia rocks like Gibraltar!
 
Posts: 262
Karma: 100000
Join Date: Oct 2012
Device: Calibre
Question
Quote:
Originally Posted by kovidgoyal View Post
fts_connect.py
Do you mean connect.py#L151?
Geremia is offline   Reply With Quote
Old 01-01-2025, 10:51 PM   #13
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,609
Karma: 28549044
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
yes, sorry typo meant to type fts/connect.py getting old
kovidgoyal is offline   Reply With Quote
Reply

Tags
calibre, calibredb, fts, fulltext search

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Log of items deleted using the REMOVE BOOKS → REMOVE MATCHING BOOKS FROM DEVICE jazzhands Calibre 8 12-06-2023 12:47 AM
Disable/Remove Full Text Index amazing2061 Library Management 2 08-31-2022 02:48 PM
Podnews podcasting news recipe - remove feed index? jamescridland Recipes 3 12-11-2018 09:21 PM
Remove Books - Restoring Confirm to remove books Caffey Calibre 6 09-20-2010 10:23 AM
fulltext search guly Calibre 2 01-10-2010 07:49 AM


All times are GMT -4. The time now is 04:25 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.