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] [Created] (OLIO-153) A query for taggings table is low efficient due to lack of appropriate indexes
Date Sun, 29 May 2011 20:17:47 GMT
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

Mime
View raw message