Utilize SQLite FTS extension
Bug #1329325 reported by
AR
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Noise |
Confirmed
|
Undecided
|
Unassigned | ||
Bug Description
Searching in noise can feel painfully slow. Since you're already using SQLite for the backend, why not take advantage of the FTS full text search extension. Full text search implementations generally behave much faster for matching text substrings, and should suit this use case very well.
More details can be found here: http://
Revision history for this message
| PerfectCarl (name-is-carl) wrote | #1 |
| Changed in noise: | |
| assignee: | nobody → PerfectCarl (name-is-carl) |
| Changed in noise: | |
| status: | New → In Progress |
| Changed in noise: | |
| assignee: | PerfectCarl (name-is-carl) → nobody |
| status: | In Progress → Confirmed |
To post a comment you must log in.
Thanks for the suggestion.
Work is being done in that direction (fts4 is great, isn't it?)