Are FTS results cached?

ownedbycats · 09-12-2022, 07:32 AM

After doing an FTS search, I switched to a different library search and did it again. The books that had appeared in the last search popped up instantly, while new results took a while to appear. This made me wonder if there's some sort of caching going on.

kovidgoyal · 09-12-2022, 10:01 AM

not in calibre code, though sqlite might be caching behind the scenes.

ownedbycats · 09-13-2022, 01:21 AM

thanks for the answer!

09-12-2022, 07:32 AM	#1
ownedbycats Custom User Title Posts: 10,592 Karma: 74166147 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Are FTS results cached? After doing an FTS search, I switched to a different library search and did it again. The books that had appeared in the last search popped up instantly, while new results took a while to appear. This made me wonder if there's some sort of caching going on.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FTS - Exporting the search	Comfy.n	Calibre	3	07-24-2023 09:01 PM
FTS results -> temporary virtual library?	slantybard	Calibre	2	08-21-2022 08:17 PM
FTS database size?	slantybard	Calibre	6	08-17-2022 04:09 AM
FTS DB maintenance functions?	DrChiper	Calibre	12	07-29-2022 07:34 PM
Forma Search-in-book results sometimes ends on page17, even if there's more (hidden)results	droopy	Kobo Reader	9	06-30-2020 11:05 AM

09-12-2022, 10:01 AM	#2
kovidgoyal creator of calibre Posts: 45,149 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	not in calibre code, though sqlite might be caching behind the scenes.

09-13-2022, 01:21 AM	#3
ownedbycats Custom User Title Posts: 10,592 Karma: 74166147 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	thanks for the answer!

Advert