add several indices to dashboard tables to enhance performance

Description

During UMich load testing of dashboard tool, we've found the following two indices useful for the tool's performance:

create index dash_calendar_link_item_id_idx on dash_calendar_link (item_id);
create index dash_news_link_item_id_idx on dash_news_link (item_id);

Will add those two indices into corresponding sql files.

Activity

Zhen Qian September 4, 2013 at 9:49 AM

r84580 added those two indices to multiple sql files.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created September 4, 2013 at 9:40 AM
Updated September 9, 2013 at 1:57 PM
Resolved September 4, 2013 at 9:49 AM