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

Investigate full text search performance #382

Open
Rikuoja opened this issue Feb 11, 2020 · 0 comments
Open

Investigate full text search performance #382

Rikuoja opened this issue Feb 11, 2020 · 0 comments
Assignees

Comments

@Rikuoja
Copy link
Contributor

Rikuoja commented Feb 11, 2020

Check whether https://docs.djangoproject.com/en/3.0/ref/contrib/postgres/search/#performance full text search would be more performant in straightforward text contains queries https://github.com/City-of-Helsinki/linkedevents/blob/master/events/api.py#L679

The full text search would need to be significantly faster than the icontains query for a production database with approx. 150 000 events, of which some thousands are in the future.

Therefore, the expected query is ?text=some_text&start=today, which filters events to those taking place in the future. If the full text search is not easily combined and fast with other filters narrowing down the queryset first, we have no use for it.

@Doatti Doatti self-assigned this Apr 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants