I don't know if sqlite allows that easily (it seems so?), but when searching through large Liferea databases, short of having a fancier search algorithm, being able to parallelize the search by automatically using all available CPU cores would allow returning results significantly faster, whether for global search or for rebuilding a Liferea search folder.
On my machine, that would be the difference between using 100% of only one core (which is what I've observed now with Liferea 1.13.9), vs using all my 8 threads/cores, which would naturally make search complete 8 times faster. Pretty much all computers have 4 CPU cores nowadays, and 16, 32 or more is not that uncommon anymore either.
I don't know if sqlite allows that easily (it seems so?), but when searching through large Liferea databases, short of having a fancier search algorithm, being able to parallelize the search by automatically using all available CPU cores would allow returning results significantly faster, whether for global search or for rebuilding a Liferea search folder.
On my machine, that would be the difference between using 100% of only one core (which is what I've observed now with Liferea 1.13.9), vs using all my 8 threads/cores, which would naturally make search complete 8 times faster. Pretty much all computers have 4 CPU cores nowadays, and 16, 32 or more is not that uncommon anymore either.