Project

General

Profile

Actions

Feature proposal #5451

closed

Improve prefetching performance

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

Status:
Closed
Priority:
Normal
Assignee:
Target version:
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 #1

Updated by krileon over 7 years ago

  • Target version changed from 754 to 4.0.0
Actions #2

Updated by krileon about 7 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 #3

Updated by krileon about 7 years ago

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

Updated by krileon almost 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF