Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
FS#49645 - [sqlite] Clementine searches are very slow until sqlite is rebuilt with some FTS3 options
Attached to Project:
Arch Linux
Opened by Chris G (epitron) - Friday, 10 June 2016, 02:28 GMT
Last edited by Andreas Radke (AndyRTR) - Friday, 10 June 2016, 14:43 GMT
Opened by Chris G (epitron) - Friday, 10 June 2016, 02:28 GMT
Last edited by Andreas Radke (AndyRTR) - Friday, 10 June 2016, 14:43 GMT
|
DetailsDescription:
Clementine library searches on my machine are maddeningly slow (10-20 seconds per keystroke). I tried the solution discussed here, and it worked: https://github.com/clementine-player/Clementine/issues/5278#issuecomment-193824433 I just had to rebuild the sqlite package with these extra defines: -DSQLITE_ENABLE_FTS3=1 \ -DSQLITE_ENABLE_FTS3_TOKENIZER=1 \ -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 \ I think this is the important feature that's missing: > SQLITE_ENABLE_FTS3_PARENTHESIS > This option modifies the query pattern parser in FTS3 such that it supports operators AND and NOT (in addition to the usual OR and NEAR) and also allows query expressions to contain nested parenthesis. |
This task depends upon
Closed by Andreas Radke (AndyRTR)
Friday, 10 June 2016, 14:43 GMT
Reason for closing: None
Additional comments about closing: closed per user request
Friday, 10 June 2016, 14:43 GMT
Reason for closing: None
Additional comments about closing: closed per user request
Sorry about that! I'll keep investigating.