Full Text Search - Allow interrupting/pausing current query

[Comfy.n]

When doing searches that return a large number of results, should it be useful to have the option to pause/interrupt the ongoing query?

I'm thinking less cpu load while browsing the results...

Also, maybe a way to export search results?

[kovidgoyal]

Start another query and it will abort the existing one. Otherwise I dont see much point.

As for exporting the results, what's the use case?

[Comfy.n]

Hi Kovid, thank you so much for implementing FTS. It works like a charm!

Use case for pausing the query would be, at least for me as a laptop user (often on battery and power saving mode, which limits CPU performance), to be able to browse through the results more "staticly", like reading a book. I know I'm not making myself much clear, so I've attached a screenshot...

Exporting the results after the long-running queries would serve that purpose as well.

found this interesting: https://www.sqlite.org/c3ref/interrupt.html

[kovidgoyal]

You can click the rotating spinner to abort the search. I'm afraid I dont find the use case for exporting compelling enough to spend time on it. At some point I will be adding support for FTS to the calibredb command at which time you can use it to export the search.

[Comfy.n]

Originally Posted by kovidgoyal

You can click the rotating spinner to abort the search. I'm afraid I dont find the use case for exporting compelling enough to spend time on it. At some point I will be adding support for FTS to the calibredb command at which time you can use it to export the search.

whee! that works!

thanks

[BetterRed]

Originally Posted by Comfy.n

Hi Kovid, thank you so much for implementing FTS. It works like a charm!

Use case for pausing the query would be, at least for me as a laptop user (often on battery and power saving mode, which limits CPU performance), to be able to browse through the results more "staticly", like reading a book. I know I'm not making myself much clear, so I've attached a screenshot...

Exporting the results after the long-running queries would serve that purpose as well.

You can export the results of text search by:

• Using the 'Mark' books feature of Text search
  You don't have to wait while it displays the snippets in the results list, as soon as it starts doing that, select Mark books->Mark all matched books in the library and then Close
• Then search book list for 'marked:true'
• Then create a Catalogue of the resultant list in a suitable format.

You can add Create Catalogue to a toolbar or menu if you can't remember where it's hidden.

BR

[Comfy.n]

Originally Posted by BetterRed

You can export the results of text search by:

• Using the 'Mark' books feature of Text search
  You don't have to wait while it displays the snippets in the results list, as soon as it starts doing that, select Mark books->Mark all matched books in the library and then Close
• Then search book list for 'marked:true'
• Then create a Catalogue of the resultant list in a suitable format.

You can add Create Catalogue to a toolbar or menu if you can't remember where it's hidden.

BR

Hmm, that looks like a nice approach, although I couldn't find something like a "results snippets" section to include in the catalog... Thanks!

[Comfy.n]

Originally Posted by kovidgoyal

At some point I will be adding support for FTS to the calibredb command at which time you can use it to export the search.

Woo-hoo, that works!