This repository has been archived by the owner on Feb 23, 2025. It is now read-only.

feat: improve bookmark text search #361

Open

1 of 3 tasks

hi-ogawa opened this issue May 4, 2023 · 0 comments · May be fixed by #382

Open

1 of 3 tasks

feat: improve bookmark text search #361

hi-ogawa opened this issue May 4, 2023 · 0 comments · May be fixed by #382

Owner

hi-ogawa commented May 4, 2023 •

edited

Loading

Following up:

Currently any text search is full scan:

db insight

Considerations:

db full text index?
- https://planetscale.com/courses/mysql-for-developers/indexes/fulltext-indexes
- https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
  - does planetscale supports FULLTEXT (xxx) WITH PARSER ngram?
  - ngram should be effective for Korean but not sure for other languages
in memory text index?
tokenize? (stem, lemma)

The text was updated successfully, but these errors were encountered:

hi-ogawa linked a pull request

that will close this issue

pref: add fulltext index for bookmarkEntries.text #382

Open

6 tasks

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.