file: support.module
line: 2219
$result = db_query('SELECT uid FROM {users} WHERE status = 1');
must be changed to db_query_range('SELECT uid FROM {users} WHERE status = 1', 0, $limit);
i have over 1000000 users and this query is very slow.

Comments

jeremy’s picture

Version: 6.x-1.5 » 7.x-1.x-dev
Status: Active » Patch (to be ported)

Good catch, committed in the 6.x-1.x branch (I made both user queries a limit, not just the one):
http://drupalcode.org/project/support.git/commit/4652e89

Needs to be ported to 7.x-1.x.

jeremy’s picture

Status: Patch (to be ported) » Fixed

Ported to 7.x-1.x (I also went ahead and converted the queries to db_select at the same time):
http://drupalcode.org/project/support.git/commit/a05804b

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.