Skip to content
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.

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

[BE] 게시글 검색 Full-text Search 적용 #263

Closed
Jinwook94 opened this issue Oct 24, 2023 · 0 comments · Fixed by #264
Closed

[BE] 게시글 검색 Full-text Search 적용 #263

Jinwook94 opened this issue Oct 24, 2023 · 0 comments · Fixed by #264
Assignees
Labels
feat New feature or request

Comments

@Jinwook94
Copy link
Owner

Jinwook94 commented Oct 24, 2023

배경

  • 게시글 조회에 검색 쿼리가 포함된 경우, LIKE 연산자의 한계로 쿼리 실행 시간이 매우 길어질 수 있음
    image
  • 위 문제 때문에 Like 연산자 사용하지 않고 Full-text Search 사용하여 응답 시간을 개선하고자 함
@Jinwook94 Jinwook94 added the feat New feature or request label Oct 24, 2023
@Jinwook94 Jinwook94 self-assigned this Oct 24, 2023
@Jinwook94 Jinwook94 linked a pull request Oct 24, 2023 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feat New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant