<?xml version="1.0"?>
<rss xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>CKAN: Ticket #1268: Speed up listing users by revisions by adding db index</title>
    <link>http://localhost/ticket/1268</link>
    <description>&lt;p&gt;
At the moment this appears to be slow (kindly suggests because missing index in db). Page is /user on a ckan instance.
&lt;/p&gt;
&lt;p&gt;
Would this also speed up user page where we recent changes?
&lt;/p&gt;
</description>
    <language>en-us</language>
    <image>
      <title>CKAN</title>
      <url>http://assets.okfn.org/p/ckan/img/ckan_logo_shortname.png</url>
      <link>http://localhost/ticket/1268</link>
    </image>
    <generator>Trac 0.12.3</generator>
    <item>
      
        <dc:creator>rgrp</dc:creator>

      <pubDate>Wed, 14 Sep 2011 15:40:14 GMT</pubDate>
      <title>description changed</title>
      <link>http://localhost/ticket/1268#comment:1</link>
      <guid isPermaLink="false">http://localhost/ticket/1268#comment:1</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;description&lt;/strong&gt;
              modified (&lt;a href="/ticket/1268?action=diff&amp;amp;version=1"&gt;diff&lt;/a&gt;)
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>kindly</dc:creator>

      <pubDate>Wed, 28 Sep 2011 12:16:08 GMT</pubDate>
      <title>status changed; owner set</title>
      <link>http://localhost/ticket/1268#comment:2</link>
      <guid isPermaLink="false">http://localhost/ticket/1268#comment:2</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;owner&lt;/strong&gt;
              set to &lt;em&gt;kindly&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;
                changed from &lt;em&gt;new&lt;/em&gt; to &lt;em&gt;assigned&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>kindly</dc:creator>

      <pubDate>Wed, 28 Sep 2011 12:21:39 GMT</pubDate>
      <title>milestone changed</title>
      <link>http://localhost/ticket/1268#comment:3</link>
      <guid isPermaLink="false">http://localhost/ticket/1268#comment:3</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;milestone&lt;/strong&gt;
                changed from &lt;em&gt;ckan-v1.5&lt;/em&gt; to &lt;em&gt;ckan-sprint-2011-10-10&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
        &lt;p&gt;
fixed cset:eebbe6071741
&lt;/p&gt;
      </description>
      <category>Ticket</category>
    </item><item>
      
        <dc:creator>kindly</dc:creator>

      <pubDate>Mon, 10 Oct 2011 20:46:32 GMT</pubDate>
      <title>status changed; resolution set</title>
      <link>http://localhost/ticket/1268#comment:4</link>
      <guid isPermaLink="false">http://localhost/ticket/1268#comment:4</guid>
      <description>
          &lt;ul&gt;
            &lt;li&gt;&lt;strong&gt;status&lt;/strong&gt;
                changed from &lt;em&gt;assigned&lt;/em&gt; to &lt;em&gt;closed&lt;/em&gt;
            &lt;/li&gt;
            &lt;li&gt;&lt;strong&gt;resolution&lt;/strong&gt;
                set to &lt;em&gt;fixed&lt;/em&gt;
            &lt;/li&gt;
          &lt;/ul&gt;
      </description>
      <category>Ticket</category>
    </item>
 </channel>
</rss>