Project

General

Profile

Actions

Bug #6973

closed

Count query performance low

Added by krileon about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
High
Assignee:
Target version:
Start date:
09 January 2018
Due date:
% Done:

100%

Estimated time:

Description

The count queries, while indexed, are still slow when hitting 100k+ rows (roughly 100-500ms). These can be eliminated entirely in most cases once timestamp pagination is implemented. However, we may still need counts for some usages (e.g. comment counts). To improve this further we maybe able to do a SUM count for a rough estimate, which will be fine for those usages or use a non-filtered count output.

Actions

Also available in: Atom PDF