Add indexes to improve performance

Description

During BugFest q3.2-2019 testing, noticed below SQL queries are slow. Adding indexes can help (see the timing number before and after).

Environment

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Hongwei Ji September 30, 2019 at 12:23 PM

Actually I have permission to create a new release for this JIRA project. Just did that and updated fixVersion

Hongwei Ji September 30, 2019 at 11:56 AM

v5.8.2 (not in JIRA).

Jakub Skoczen September 30, 2019 at 11:49 AM

what was the fixVersion here?

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Core: Platform

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created September 20, 2019 at 8:05 PM
Updated October 15, 2019 at 10:03 AM
Resolved September 26, 2019 at 1:52 AM
TestRail: Cases
TestRail: Runs