Actions
Bug #7930
closed
Category group count query too slow
Description
A category with a million group rows counts the group rows too slowly. This causes pages to hang hurting scale-ability of GJ.
Updated by krileon over 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.
Updated by krileon over 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