You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by "Liang Zhao (JIRA)" <ji...@apache.org> on 2011/05/29 20:17:47 UTC
[jira] [Created] (OLIO-153) A query for taggings table is low
efficient due to lack of appropriate indexes
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
[jira] [Resolved] (OLIO-153) A query for taggings table is low
efficient due to lack of appropriate indexes
Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OLIO-153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shanti Subramanyam resolved OLIO-153.
-------------------------------------
Resolution: Fixed
Fix Version/s: 0.2
0.1
Added patch to webapp/rails/trunk/db/migrate
> 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
> Fix For: 0.1, 0.2
>
> 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
[jira] [Closed] (OLIO-153) A query for taggings table is low
efficient due to lack of appropriate indexes
Posted by "Shanti Subramanyam (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OLIO-153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shanti Subramanyam closed OLIO-153.
-----------------------------------
> 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
> Fix For: 0.1, 0.2
>
> 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
[jira] [Updated] (OLIO-153) A query for taggings table is low
efficient due to lack of appropriate indexes
Posted by "Liang Zhao (JIRA)" <ji...@apache.org>.
[ 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