Category group count query too slow
Added by krileon almost 3 years ago.
Updated almost 2 years ago.
A category with a million group rows counts the group rows too slowly. This causes pages to hang hurting scale-ability of GJ.
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.
- 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.
- Status changed from Resolved to Closed
Also available in: Atom