Closed (fixed)
Project:
Support Ticketing System
Version:
7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
12 Nov 2011 at 17:25 UTC
Updated:
27 Nov 2011 at 22:00 UTC
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
Comment #1
jeremy commentedGood 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.
Comment #2
jeremy commentedPorted 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