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.

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

Add DB indexes to support multiple filters #472

Open
kracekumar opened this issue Jul 6, 2016 · 0 comments
Open

Add DB indexes to support multiple filters #472

kracekumar opened this issue Jul 6, 2016 · 0 comments
Assignees
@pythonhacker
Labels
area/api priority/long-term type/enhancement
Milestone
Enhancements

Comments

@kracekumar
Copy link
Member

Junction has a large number of filters around conference, proposals, comment, proposal type, and section. As long as these filters are on foreign key, performance is fine. The problem arises when the filter is applied on more than one field. Investigate all queries and add necessary index.
@pythonhacker pythonhacker self-assigned this Apr 6, 2017
@ananyo2012 ananyo2012 changed the title DB index Add DB indexes to support multiple filters Mar 19, 2020
@palnabarun palnabarun added this to the Enhancements milestone Mar 20, 2020
@pradyunsg pradyunsg removed the Backend label Mar 21, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pythonhacker pythonhacker

Labels
area/api priority/long-term type/enhancement
Projects
None yet
Milestone
Enhancements
Development

No branches or pull requests
6 participants
@kracekumar @pythonhacker @pradyunsg @ChillarAnand @palnabarun @ananyo2012