Project

General

Profile

Actions
Copy link

Bug #6972

closed

Activity index not being used

Added by krileon almost 7 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
krileon
Target version:
4.2.0
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
Copy link
 #1

Updated by krileon almost 7 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
Copy link
 #2

Updated by krileon almost 7 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF