Hallo there,
I am using CB 1.8.1, and recently upgraded to j2.5
Since the upgrade, the page that shows the default users list became very very slow.
Checking mysqldumpslow I see that the biggest offender is a query used only by CB. As far as I can see it is only used on that page:
SELECT DISTINCT ue.*, u.*, 'S' AS 'S' FROM #__users u
JOIN #__user_usergroup_map g ON g.`user_id` = u.`id`
JOIN #__comprofiler ue ON ue.`id` = u.`id`
WHERE u.block = N
AND ue.approved = N
AND ue.confirmed = N
AND ue.banned = N
AND g.group_id IN (N)
ORDER BY `username` ASC LIMIT N, N
Doing a little digging, I see that the problem is caused by the "ORDER BY username", which on its own does not present any problem (username has an index and everything).
The users list is 50.000 big.
Anyone else have had similar issues? If yes, any suggestion?
Thanks
