Project

General

Profile

Actions

Bug #6972

closed

Activity index not being used

Added by krileon about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Target version:
Start date:
09 January 2018
Due date:
% Done:

100%

Estimated time:

Description

The index for activity table is not being used. This is causing queries to be A LOT slower than expected. Review fixing the indexes to allow for better performance.

Actions #1

Updated by krileon about 6 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Asset column was not necessary in the index. 2 indexes are also needed to cover pinned and non-pinned usage cases.

Actions #2

Updated by krileon about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF