Return-Path: X-Original-To: notmuch@notmuchmail.org Delivered-To: notmuch@notmuchmail.org Received: from localhost (localhost [127.0.0.1]) by olra.theworths.org (Postfix) with ESMTP id 8365E431FB6 for ; Thu, 5 May 2011 01:17:20 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at olra.theworths.org X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 tagged_above=-999 required=5 tests=[none] autolearn=disabled Received: from olra.theworths.org ([127.0.0.1]) by localhost (olra.theworths.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id zF7KKVMaLyI7 for ; Thu, 5 May 2011 01:17:20 -0700 (PDT) Received: from imarko.xen.prgmr.com (imarko.xen.prgmr.com [72.13.95.244]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by olra.theworths.org (Postfix) with ESMTPS id 15566431FB5 for ; Thu, 5 May 2011 01:17:20 -0700 (PDT) Received: from localhost ([127.0.0.1] helo=zsu.kismala.com) by imarko.xen.prgmr.com with esmtp (Exim 4.72) (envelope-from ) id 1QHtkM-0003SA-QJ; Thu, 05 May 2011 01:17:19 -0700 From: Istvan Marko To: Austin Clements Subject: Re: storing From and Subject in xapian References: Date: Thu, 05 May 2011 01:17:18 -0700 In-Reply-To: (Austin Clements's message of "Wed, 4 May 2011 21:48:39 -0400") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain Cc: notmuch@notmuchmail.org X-BeenThere: notmuch@notmuchmail.org X-Mailman-Version: 2.1.13 Precedence: list List-Id: "Use and development of the notmuch mail system." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 May 2011 08:17:20 -0000 Austin Clements writes: > This is awesome. What was your machine configuration? Reasonably modern linux box, Core i5. Both the xapian db and the mail files are on the same 7200 RPM SATA drive, ext4 filesystem. I guess the SSD might explain why you your uncached results are not as bad as mine. My test search matches 8800 messages grouped into 5550 threads. Wit the patch cached results go from 2.5 secs to 1.5, uncached goes from 40 secs to 6. Thanks for the clue on the missing subject lines, your change does indeed fix the problem! -- Istvan