Project

General

Profile

Actions

Bug #7930

closed

Category group count query too slow

Added by krileon almost 4 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
08 April 2020
Due date:
% Done:

100%

Estimated time:

Description

A category with a million group rows counts the group rows too slowly. This causes pages to hang hurting scale-ability of GJ.

Actions #1

Updated by krileon almost 3 years ago

Only way to really fix this is to do a less accurate query. Basically just do a count regardless of group published state, etc.. This helps with the All Categories page, but won't help when directly viewing a category since we need the count for pagination.

Actions #2

Updated by krileon almost 3 years ago

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

Fixed with new query index. From 30 seconds down to 200ms for over 1 million groups.

Actions #3

Updated by krileon almost 3 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF