Project

General

Profile

Actions
Copy link

Feature proposal #5451

closed

Improve prefetching performance

Added by krileon over 9 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
4.0.0
Start date:
12 August 2015
Due date:
% Done:

100%

Estimated time:

Description

Improve comment/tag count prefetching performance. Try using a simple subquery select instead of a separate function that does a large count query. See GJ for example of this.

Actions
Copy link
 #1

Updated by krileon over 8 years ago

  • Target version changed from 754 to 4.0.0
Actions
Copy link
 #2

Updated by krileon almost 8 years ago

  • % Done changed from 0 to 50

These are now just subqueries of the activity query. This reduces 3 queries down to 1. Still needs indexing.

Actions
Copy link
 #3

Updated by krileon almost 8 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 50 to 100
Actions
Copy link
 #4

Updated by krileon over 7 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF