New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[REFACT] 사용자에 대한 태그 혹은 이름 검색시 발생하는 쿼리 개선 #22

Open

2 tasks

minje0204 opened this issue Oct 23, 2024 · 0 comments

Assignees

Labels

♻️ refactor

Collaborator

minje0204 commented Oct 23, 2024 •

edited

Loading

🔥Description

'키워드로 사용자 검색' API 동작시 아래와 같은 쿼리 발생

select *
from member m1_0
where m1_0.tag like '%{tag}%' escape '!' or m1_0.name like '%{name}%' escape '!'
limit 1

앞쪽에 와일드카드(%)가 있는경우 인덱스가 적용되지 않으며, Full Scan 발생

✅ Todo

Full-text Search
- https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
- https://www.postgresql.org/docs/current/textsearch.html
앞쪽 와일드 카드 제거

minje0204 added the ♻️ refactor label

minje0204 self-assigned this

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