4
I've upgraded one site from 2.3.2 into 2.5.4 and notice one problem (only).
The admin->users page produces a query that takes down my all site, this is the query produced here at xoops.org:
14.787788 - SELECT DISTINCT u.* FROM users AS u LEFT JOIN groups_users_link AS m ON m.uid = u.uid WHERE 1 = 1 AND (level >= '0') ORDER BY user_regdate DESC LIMIT 0, 20
code that produces this query is this one:
$users_arr = $member_handler->getUsersByGroupLink($groups, $criteria, true);
We need to see how we can optimize this. It is locking the table and produces a lot of pending 'select user' queries. In an active site as mine, accessing admin->users in admin siide brings server to its knees.
I've temporarily changed this line into
$users_arr = $member_handler->getUsers($criteria, true);
