Project

General

Profile

Bug #7970

Missing table indexes in 1.10

Added by Yannick Warnier almost 4 years ago. Updated almost 4 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
Category:
Database & API changes
Target version:
Start date:
17/11/2015
Due date:
% Done:

100%

Estimated time:
Spent time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

Here are a few indexes that should be added to the database creation and migration procedures:

  • alter table group_rel_user add index idx_gru_cid (c_id);
  • alter table group_rel_user add index idx_gru_uid (user_id);
  • alter table user add index idx_user_uid (user_id);
  • alter table user_rel_tag add index idx_urt_uid (user_id);
  • alter table user_rel_tag add index idx_urt_tid (tag_id);

Tested on free campus.

Associated revisions

Revision 2c93a77e (diff)
Added by Angel Fernando Quiroz Campos almost 4 years ago

Add new indexes - refs #7970

Revision 1b2279f6 (diff)
Added by Angel Fernando Quiroz Campos almost 4 years ago

Fix index on UserRelTag - refs #7970

Revision 76461821 (diff)
Added by Angel Fernando Quiroz Campos almost 4 years ago

Add new indexes on extra_field and extra_field_values - refs #7970

History

#1

Updated by Angel Quiroz almost 4 years ago

  • Status changed from Assigned to Bug resolved
  • % Done changed from 0 to 100

New indexes added

#2

Updated by Yannick Warnier almost 4 years ago

  • Status changed from Bug resolved to Assigned
  • % Done changed from 100 to 80

Please also add this:

alter table extra_field_values add index idx_extra_field_value_type_item (field_id, item_id);
alter table extra_field add index idx_extra_field_type (extra_field_type);

Without this, user profile read and edition can be very slow.

#3

Updated by Angel Quiroz almost 4 years ago

  • Status changed from Assigned to Bug resolved
  • % Done changed from 80 to 100

Indexes added on Version20151214164000 migration

Also available in: Atom PDF