admin/changegroupassign.php
Posted: Mon Apr 03, 2006 6:40 pm
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
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?
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";
So it comes cmsms has not been built to support a great (but 3000 is not so great) number of users.
Any suggestion?