Return-Path: X-Original-To: apmail-incubator-allura-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-allura-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 CF85510A55 for ; Tue, 18 Feb 2014 21:59:43 +0000 (UTC) Received: (qmail 59474 invoked by uid 500); 18 Feb 2014 21:59:43 -0000 Delivered-To: apmail-incubator-allura-dev-archive@incubator.apache.org Received: (qmail 59451 invoked by uid 500); 18 Feb 2014 21:59:43 -0000 Mailing-List: contact allura-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: allura-dev@incubator.apache.org Delivered-To: mailing list allura-dev@incubator.apache.org Received: (qmail 59443 invoked by uid 99); 18 Feb 2014 21:59:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Feb 2014 21:59:43 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of noreply@sourceforge.net designates 216.34.181.60 as permitted sender) Received: from [216.34.181.60] (HELO smtp.ch3.sourceforge.com) (216.34.181.60) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Feb 2014 21:59:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=sourceforge.com; s=x; h=Date:References:In-Reply-To:Message-ID:Subject:Reply-To:From:To:MIME-Version:Content-Type; bh=F0PWfOwbooSJPmDYivugByBD3eNRCkum/g68gb+Tiag=; b=Npeh1OGEyKJ8ro7ZlXSc7OtkURq29ZB7xyMsCh0lxcKHQn09cAnQPifU/fU+YDMCPTwr/fY8WCFeJ37UAZASgaWkj8ljg9yc/+aO1Q6Dr5jeRIqKWU5cnFqhkRYsBKwaxBCaGvBWiyvr8yUkaNpVvFzUM/r46+qPhI1uulWkJn0=; Received: from localhost ([127.0.0.1] helo=sfs-alluradaemon-3.v29.ch3.sourceforge.com) by sfs-alluradaemon-3.v29.ch3.sourceforge.com with esmtp (Exim 4.76) (envelope-from ) id 1WFshA-00066C-J7 for allura-dev@incubator.apache.org; Tue, 18 Feb 2014 21:59:16 +0000 Content-Type: multipart/related; boundary="===============6909815427453103675==" MIME-Version: 1.0 To: allura-dev@incubator.apache.org From: "Dave Brondsema" Reply-To: "[allura:tickets] " <7186@tickets.allura.p.re.sf.net> Subject: [allura:tickets] #7186 Need index on artifact_feed (project_id, pubdate) NEEDS ENSURE_INDEX Message-ID:

In-Reply-To: <5303d38d81b24b40a3c468e3.tickets@allura.p.sourceforge.net> References: <5303d38d81b24b40a3c468e3.tickets@allura.p.sourceforge.net> Date: Tue, 18 Feb 2014 21:59:16 +0000 X-Virus-Checked: Checked by ClamAV on apache.org --===============6909815427453103675== Content-Type: multipart/alternative; boundary="===============0047725692863989190==" MIME-Version: 1.0 --===============0047725692863989190== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit - Description has changed: Diff: ~~~~ --- old +++ new @@ -1 +1 @@ -While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate. The sort pat isn't indexed. +While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate. The sort part isn't indexed. ~~~~ - **status**: in-progress --> code-review --- ** [tickets:#7186] Need index on artifact_feed (project_id, pubdate) NEEDS ENSURE_INDEX** **Status:** code-review **Labels:** performance **Created:** Tue Feb 18, 2014 09:41 PM UTC by Dave Brondsema **Last Updated:** Tue Feb 18, 2014 09:41 PM UTC **Owner:** Dave Brondsema While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate. The sort part isn't indexed. --- Sent from sourceforge.net because allura-dev@incubator.apache.org is subscribed to https://sourceforge.net/p/allura/tickets/ To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/allura/admin/tickets/options. Or, if this is a mailing list, you can unsubscribe from the mailing list. --===============0047725692863989190== MIME-Version: 1.0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: 7bit
  • Description has changed:

Diff:

--- old
+++ new
@@ -1 +1 @@
-While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate.  The sort pat isn't indexed.
+While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate.  The sort part isn't indexed.
  • status: in-progress --> code-review

[tickets:#7186] Need index on artifact_feed (project_id, pubdate) NEEDS ENSURE_INDEX

Status: code-review
Labels: performance
Created: Tue Feb 18, 2014 09:41 PM UTC by Dave Brondsema
Last Updated: Tue Feb 18, 2014 09:41 PM UTC
Owner: Dave Brondsema

While we may want to redirect /p/test/feed.rss to /p/test/activity/feed.rss, at the current point it does a query on artifact_feed by project_id and sorts by pubdate. The sort part isn't indexed.

Sent from sourceforge.net because allura-dev@incubator.apache.org is subscribed to https://sourceforge.net/p/allura/tickets/

To unsubscribe from further messages, a project admin can change settings at https://sourceforge.net/p/allura/admin/tickets/options. Or, if this is a mailing list, you can unsubscribe from the mailing list.

--===============0047725692863989190==-- --===============6909815427453103675==--