admin/changegroupassign.php

[vronsky]

hello,
i'm actually using a version 0.11.2 in local testing, win xp 2400Mhz 1Gbram.

I'm wondering that , having about 3000 users, and about 5 user_groups, at the page
admin/changegroupassign.php, lines 86,87
the query

Code: Select all

$query = "SELECT u.user_id, u.username, ug.group_id FROM ".cms_db_prefix()."users u LEFT JOIN ".
            cms_db_prefix()."user_groups ug ON u.user_id = ug.user_id and group_id = ? ORDER BY u.username";

cause MySqld to load 100% cpu, then fails exceeding MAX_EXECUTION_TIME (I suppose).
So it comes cmsms has not been built to support a great (but 3000 is not so great) number of users.
Any suggestion?