Project

General

Profile

Actions
Copy link

Bug #7545

closed

Backend views performance issues

Added by krileon over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
krileon
Target version:
5.0.0
Start date:
07 May 2019
Due date:
% Done:

100%

Estimated time:

Description

With large amount of data some of the backend views (e.g. Likes) stall. Review their SQL and improve where needed as they should not be slow as it makes management impossible.

Actions
Copy link
 #1

Updated by krileon over 5 years ago

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

Only impacted Likes view due to JOIN for like type. Changed to subquery for better performance.

Actions
Copy link
 #2

Updated by krileon over 5 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF