From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <david@tethera.net>
Received: from localhost (localhost [127.0.0.1])
 by arlo.cworth.org (Postfix) with ESMTP id 12AA06DE12F3
 for <notmuch@notmuchmail.org>; Sun, 20 Aug 2017 18:35:56 -0700 (PDT)
X-Virus-Scanned: Debian amavisd-new at cworth.org
X-Spam-Flag: NO
X-Spam-Score: 0
X-Spam-Level: 
X-Spam-Status: No, score=0 tagged_above=-999 required=5 tests=[AWL=0.011,
 SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled
Received: from arlo.cworth.org ([127.0.0.1])
 by localhost (arlo.cworth.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 4yQ3cdRyJLD5 for <notmuch@notmuchmail.org>;
 Sun, 20 Aug 2017 18:35:55 -0700 (PDT)
Received: from fethera.tethera.net (fethera.tethera.net [198.245.60.197])
 by arlo.cworth.org (Postfix) with ESMTPS id 397096DE12F0
 for <notmuch@notmuchmail.org>; Sun, 20 Aug 2017 18:35:55 -0700 (PDT)
Received: from remotemail by fethera.tethera.net with local (Exim 4.89)
 (envelope-from <david@tethera.net>)
 id 1djbZh-0001yA-R8; Sun, 20 Aug 2017 21:32:17 -0400
Received: (nullmailer pid 30132 invoked by uid 1000);
 Mon, 21 Aug 2017 01:35:49 -0000
From: David Bremner <david@tethera.net>
To: Jani Nikula <jani@nikula.org>, notmuch@notmuchmail.org
Subject: Re: [PATCH] WIP: add thread subqueries.
In-Reply-To: <20170820213240.20526-1-david@tethera.net>
References: <87378ml59b.fsf@nikula.org>
 <20170820213240.20526-1-david@tethera.net>
Date: Sun, 20 Aug 2017 22:35:49 -0300
Message-ID: <87efs5g0sq.fsf@tethera.net>
MIME-Version: 1.0
Content-Type: text/plain
X-BeenThere: notmuch@notmuchmail.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: "Use and development of the notmuch mail system."
 <notmuch.notmuchmail.org>
List-Unsubscribe: <https://notmuchmail.org/mailman/options/notmuch>,
 <mailto:notmuch-request@notmuchmail.org?subject=unsubscribe>
List-Archive: <http://notmuchmail.org/pipermail/notmuch/>
List-Post: <mailto:notmuch@notmuchmail.org>
List-Help: <mailto:notmuch-request@notmuchmail.org?subject=help>
List-Subscribe: <https://notmuchmail.org/mailman/listinfo/notmuch>,
 <mailto:notmuch-request@notmuchmail.org?subject=subscribe>
X-List-Received-Date: Mon, 21 Aug 2017 01:35:56 -0000

David Bremner <david@tethera.net> writes:


> If you're interested in this feature, please test, let me know if it's
> workable for your use case.  The syntax here is thread:{$query}. The
> usual caveats about whitespace apply. The running example is
>
> 	     thread:{from:me} and thread:{from:jian} and not thread:{from:dave}
>

I was playing around with this, and

  'thread:"{from:bremner and date:2017}"' and thread:{from:sitaram}

is about 10x faster than without the date restriction. This is roughly
proportional to the number of threads matching the first subquery.
Unfortunately the date restriction needs to be inside the subquery with
the current design.

d