[
https://issues.apache.org/jira/browse/OLIO-153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Liang Zhao updated OLIO-153:
----------------------------
Attachment: 201105200500908_more_indexes.rb
A MoreIndex class for migration.
> 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
> Labels: index, taggings
> Attachments: 201105200500908_more_indexes.rb
>
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> 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
