alter table project_issues add index sid (sid);

CommentFileSizeAuthor
#3 sid_index.patch1.68 KBhunmonk
#2 project_issue_106654.patch1.59 KBdrewish

Comments

drewish’s picture

drewish commented
Assigned: Unassigned » drewish

i'll get this.

drewish’s picture

drewish commented
Status: Active » Needs review
StatusFileSize
new project_issue_106654.patch1.59 KB

working on this i noticed that we're missing some pgsql indexes. i created a patch for that over on #164958. this patch sort of conflicts with it but i'll post it and we can sort out the commit order later.

hunmonk’s picture

hunmonk commented
Status: Needs review » Reviewed & tested by the community
StatusFileSize
new sid_index.patch1.68 KB

updated patch attached. this has been tested as working for both a fresh install and an upgrade on mysql/pgsql.

dww’s picture

dww
we/he/they
commented
Status: Reviewed & tested by the community » Fixed

Great, thanks, folks. Committed to HEAD, backported to DRUPAL-4-7--2 and DRUPAL-4-7 as project_issue_update_4() and committed.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)