The {support_assigned} primary key is currently (uid, nid). This is backwards for two reasons.

A) In general usage, there are many more tickets than users.
B) None of the queries attempt to find nid from uid, but several attempt to find uid from nid.

Comments

bdragon’s picture

bdragon commented
Version: 7.x-1.x-dev » 6.x-1.x-dev
Assigned: bdragon » jeremy
Issue tags: +Needs backport to D6

Fixed in 7.x-1.x.
http://drupalcode.org/project/support.git/commit/6f20409eccc5d72753f059a...

bdragon’s picture

bdragon commented

Followup on D7:
After discussion with Jermey, added a secondary index on uid so we don't slow down a couple of less common queries.
http://drupalcode.org/project/support.git/commit/43733f6dffe5c4710061d5c...

jeremy’s picture

jeremy commented
Status: Active » Fixed

Committed to 6.x -- thanks Brandon!
http://drupalcode.org/project/support.git/commit/ca5a380

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