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

[refactor] 지역 검색 FullTextIndex 적용 #114

Closed

stophwan opened this issue Sep 16, 2024 · 0 comments · Fixed by #115

Assignees

Labels

Member

stophwan commented Sep 16, 2024

리팩토링할 부분 설명

지역 검색 쿼리를 현재 LIKE 방식에 FullTextIndex를 적용합니다.

리팩토링 필요성

LIKE '%검색쿼리%' 방식은 인덱스를 적용하기 어려워 성능의 개선이 필요합니다.
'서울 송파'와 같은 사용자의 입력에 아무런 값도 반환하지 않습니다.

리팩토링 방법

지역에 FullTextIndex를 적용합니다.

stophwan added the 💊 refactor label

stophwan self-assigned this

stophwan mentioned this issue

[BLOOM-114] 지역검색 쿼리 fulltext search 적용 #115

Merged

stophwan closed this as completed in #115

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