[OLIO-153] A query for taggings table is low efficient due to lack of appropriate indexes

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.2
• Fix Version/s: 0.1, 0.2
• Component/s: rails-loader
• Labels: index taggings
• Environment: Ubuntu Linux, Ruby On Rails
• Assignee: Shanti Subramanyam
• Reporter: Liang Zhao
• Created: 29/May/11 20:16
• Updated: 19/Jul/11 05:36
• Resolved: 19/Jul/11 05:36

Description

A query in AddEvent transaction:

SELECT * FROM `taggings` WHERE (`taggings`.taggable_id = 76 AND `taggings`.taggable_type = 'Event');

requires indexes on taggable_id and tggable_type to improve its performance. Otherwise, the query needs to scan the whole table all the time.