junction
junction copied to clipboard
Add DB indexes to support multiple filters
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.