Re: [sup-talk] Sorting

From: Michael McDermott <mmcdermott@mad-computer-scientist.com>
To: sup-talk <sup-talk@rubyforge.org>
Subject: Re: [sup-talk] Sorting
Date: Mon, 14 Dec 2009 14:45:28 -0600	[thread overview]
Message-ID: <1260822912-sup-2952@zion> (raw)
In-Reply-To: <1260810592-sup-4853@nixos>

The thing that brought it to mind was search results. In particular, I was
searching for messages with a particular label, then wanting to sort them by
date. (I am running sup version 0.8.1, installed from the Jaunty repositories,
if that is of any help).

At least at my current version, the messages were not in a chronological order.
There were messages from the last couple of days interleaved for the first few
pages.

That said, I am sure that arbitrary sorting would be useful. Heck, even 
Thunderbird and Outlook (much less powerful though they be) allow messages to be
sorted by fields other than date received.

Excerpts from Marc Weber's message of Mon Dec 14 11:13:01 -0600 2009:
> Excerpts from Michael McDermott's message of Mon Dec 14 18:01:39 +0100 2009:
> > After running a search in Sup, is there any way to sort the result set? Or,
> > perhaps, specify the ordering in the query? (ala SQL)
> 
> Hi McDermott
> 
> Sup is lazy.
> 
> It only searches as much results as fit on screen unless you use !!
> I think threads are sorted by date which makes much sense.
> 
> You propose that you want a ORDER BY feature.
> >From SQL you should also know that this forces the database to fetch all
> rows even if you're interested only in LIMIT 1.
> 
> So try !! and wait. If it' fast enough tell so. If it's not think about
> another way to solve you real problem. Maybe just put your real problem
> here. There may be a different solution.
> 
> You want to stort your threads by which field?
> 
> Marc Weber
-- 
Michael McDermott
www.mad-computer-scientist.com
_______________________________________________
sup-talk mailing list
sup-talk@rubyforge.org
http://rubyforge.org/mailman/listinfo/sup-talk