A query for taggings table is low efficient due to lack of appropriate indexes
------------------------------------------------------------------------------
Key: OLIO-153
URL: https://issues.apache.org/jira/browse/OLIO-153
Project: Olio
Issue Type: Improvement
Components: rails-loader
Affects Versions: 0.2
Environment: Ubuntu Linux, Ruby On Rails
Reporter: Liang Zhao
Assignee: Shanti Subramanyam
Priority: Minor
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.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
