Actions
Bug #7930
closedCategory 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.
Actions
Added by krileon almost 5 years ago. Updated almost 4 years ago.
Description
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.
Fixed with new query index. From 30 seconds down to 200ms for over 1 million groups.