Project

General

Profile

Actions
Copy link

Feature proposal #5451

closed

Improve prefetching performance

Feature proposal #5451: Improve prefetching performance

Added by krileon over 10 years ago. Updated almost 9 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.

Updated by krileon over 9 years ago Actions
Copy link
 #1

  • Target version changed from 754 to 4.0.0

Updated by krileon about 9 years ago Actions
Copy link
 #2

  • % 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.

Updated by krileon about 9 years ago Actions
Copy link
 #3

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

Updated by krileon almost 9 years ago Actions
Copy link
 #4

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: PDF Atom