From mboxrd@z Thu Jan 1 00:00:00 1970 Received: by 10.90.27.4 with SMTP id a4cs178998aga; Mon, 14 Dec 2009 09:13:38 -0800 (PST) Received: by 10.224.80.98 with SMTP id s34mr3116704qak.98.1260810817871; Mon, 14 Dec 2009 09:13:37 -0800 (PST) Return-Path: Received: from rubyforge.org (rubyforge.org [205.234.109.19]) by mx.google.com with ESMTP id 6si12381732qwk.21.2009.12.14.09.13.37; Mon, 14 Dec 2009 09:13:37 -0800 (PST) Received-SPF: pass (google.com: domain of sup-talk-bounces@rubyforge.org designates 205.234.109.19 as permitted sender) client-ip=205.234.109.19; Authentication-Results: mx.google.com; spf=pass (google.com: domain of sup-talk-bounces@rubyforge.org designates 205.234.109.19 as permitted sender) smtp.mail=sup-talk-bounces@rubyforge.org Received: from rubyforge.org (rubyforge.org [127.0.0.1]) by rubyforge.org (Postfix) with ESMTP id 9416B1D78874; Mon, 14 Dec 2009 12:13:37 -0500 (EST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by rubyforge.org (Postfix) with SMTP id E4C591779938 for ; Mon, 14 Dec 2009 12:13:26 -0500 (EST) Received: (qmail invoked by alias); 14 Dec 2009 17:13:23 -0000 Received: from mawercer.at.xencon.net (EHLO mail.gmx.net) [83.246.111.127] by mail.gmx.net (mp064) with SMTP; 14 Dec 2009 18:13:23 +0100 X-Authenticated: #9006135 X-Provags-ID: V01U2FsdGVkX1/3Z8ZJ7ln3R0B3Uz/85lRzBOx7IDTUFk07uPSjIh MvBj3YXwZHkxE0 Received: by mail.gmx.net (sSMTP sendmail emulation); Mon, 14 Dec 2009 18:13:01 +0100 From: Marc Weber To: sup-talk In-reply-to: <1260809732-sup-4895@zion> References: <1260809732-sup-4895@zion> Date: Mon, 14 Dec 2009 18:13:01 +0100 Message-Id: <1260810592-sup-4853@nixos> User-Agent: Sup/git X-Y-GMX-Trusted: 0 X-FuHaFi: 0.6 Subject: Re: [sup-talk] Sorting X-BeenThere: sup-talk@rubyforge.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: User & developer discussion of Sup List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: sup-talk-bounces@rubyforge.org Errors-To: sup-talk-bounces@rubyforge.org 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 _______________________________________________ sup-talk mailing list sup-talk@rubyforge.org http://rubyforge.org/mailman/listinfo/sup-talk