From olio-dev-return-958-apmail-incubator-olio-dev-archive=incubator.apache.org@incubator.apache.org Sun May 29 20:20:29 2011 Return-Path: X-Original-To: apmail-incubator-olio-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-olio-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 30CA84EF7 for ; Sun, 29 May 2011 20:20:29 +0000 (UTC) Received: (qmail 58927 invoked by uid 500); 29 May 2011 20:20:28 -0000 Delivered-To: apmail-incubator-olio-dev-archive@incubator.apache.org Received: (qmail 58906 invoked by uid 500); 29 May 2011 20:20:28 -0000 Mailing-List: contact olio-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: olio-dev@incubator.apache.org Delivered-To: mailing list olio-dev@incubator.apache.org Received: (qmail 58898 invoked by uid 99); 29 May 2011 20:20:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 29 May 2011 20:20:28 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 29 May 2011 20:20:27 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 5A10DE7239 for ; Sun, 29 May 2011 20:19:47 +0000 (UTC) Date: Sun, 29 May 2011 20:19:47 +0000 (UTC) From: "Liang Zhao (JIRA)" To: olio-dev@incubator.apache.org Message-ID: <1077692832.52241.1306700387365.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1710217506.52228.1306700267538.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Updated] (OLIO-153) A query for taggings table is low efficient due to lack of appropriate indexes MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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