Category group count query too slow
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 almost 2 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.