incubator-olio-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liang Zhao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OLIO-153) A query for taggings table is low efficient due to lack of appropriate indexes
Date Sun, 29 May 2011 20:19:47 GMT

     [ 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

Mime
View raw message