1 Return-Path: <daniel@schoepe.org>
\r
2 X-Original-To: notmuch@notmuchmail.org
\r
3 Delivered-To: notmuch@notmuchmail.org
\r
4 Received: from localhost (localhost [127.0.0.1])
\r
5 by olra.theworths.org (Postfix) with ESMTP id 59780429E21
\r
6 for <notmuch@notmuchmail.org>; Sun, 6 Nov 2011 13:41:51 -0800 (PST)
\r
7 X-Virus-Scanned: Debian amavisd-new at olra.theworths.org
\r
11 X-Spam-Status: No, score=-0.79 tagged_above=-999 required=5
\r
12 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1,
\r
13 RCVD_IN_DNSWL_LOW=-0.7, T_MIME_NO_TEXT=0.01] autolearn=disabled
\r
14 Received: from olra.theworths.org ([127.0.0.1])
\r
15 by localhost (olra.theworths.org [127.0.0.1]) (amavisd-new, port 10024)
\r
16 with ESMTP id 9biOxnv53Adm for <notmuch@notmuchmail.org>;
\r
17 Sun, 6 Nov 2011 13:41:50 -0800 (PST)
\r
18 Received: from mail-fx0-f53.google.com (mail-fx0-f53.google.com
\r
19 [209.85.161.53]) (using TLSv1 with cipher RC4-SHA (128/128 bits))
\r
20 (No client certificate requested)
\r
21 by olra.theworths.org (Postfix) with ESMTPS id 553A4431FB6
\r
22 for <notmuch@notmuchmail.org>; Sun, 6 Nov 2011 13:41:50 -0800 (PST)
\r
23 Received: by faan15 with SMTP id n15so1758595faa.26
\r
24 for <notmuch@notmuchmail.org>; Sun, 06 Nov 2011 13:41:49 -0800 (PST)
\r
25 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=schoepe.org; s=google;
\r
26 h=from:to:cc:subject:in-reply-to:references:user-agent:date
\r
27 :message-id:mime-version:content-type;
\r
28 bh=hF6kYFAJ0ZtBgR8fJ+016ho8z2/q9ZMIs596A7TghRY=;
\r
29 b=be4Mvyj8XL0lqxmGKFpKWxW0qViuXLmKYC6SJUQhTjnaSKEF4J42mhd7P/6p4IbVij
\r
30 6hkiFmdCO6jxPBSDlyxtMS7PKjnCHSJGVBeBvI+AV0Igv/gzYCewpVaUmoAzTO93CCBi
\r
31 ZkG16jYVdWtZQTvLojHfiMkZvNDabf9ZKbEvc=
\r
32 Received: by 10.223.7.20 with SMTP id b20mr41991959fab.21.1320615708894;
\r
33 Sun, 06 Nov 2011 13:41:48 -0800 (PST)
\r
34 Received: from localhost (dslb-178-004-074-193.pools.arcor-ip.net.
\r
36 by mx.google.com with ESMTPS id y2sm28478556fag.12.2011.11.06.13.41.45
\r
37 (version=TLSv1/SSLv3 cipher=OTHER);
\r
38 Sun, 06 Nov 2011 13:41:47 -0800 (PST)
\r
39 From: Daniel Schoepe <daniel@schoepe.org>
\r
40 To: Austin Clements <amdragon@MIT.EDU>, notmuch@notmuchmail.org
\r
41 Subject: Re: [PATCH] Store "from" and "subject" headers in the database.
\r
42 In-Reply-To: <1320599856-24078-1-git-send-email-amdragon@mit.edu>
\r
43 References: <1320599856-24078-1-git-send-email-amdragon@mit.edu>
\r
44 User-Agent: Notmuch/0.9+96~g2c80672 (http://notmuchmail.org) Emacs/23.3.1
\r
45 (x86_64-pc-linux-gnu)
\r
46 Date: Sun, 06 Nov 2011 22:41:32 +0100
\r
47 Message-ID: <87d3d5kjxv.fsf@gilead.invalid>
\r
49 Content-Type: multipart/signed; boundary="=-=-=";
\r
50 micalg=pgp-sha1; protocol="application/pgp-signature"
\r
51 Cc: notmuch@kismala.com
\r
52 X-BeenThere: notmuch@notmuchmail.org
\r
53 X-Mailman-Version: 2.1.13
\r
55 List-Id: "Use and development of the notmuch mail system."
\r
56 <notmuch.notmuchmail.org>
\r
57 List-Unsubscribe: <http://notmuchmail.org/mailman/options/notmuch>,
\r
58 <mailto:notmuch-request@notmuchmail.org?subject=unsubscribe>
\r
59 List-Archive: <http://notmuchmail.org/pipermail/notmuch>
\r
60 List-Post: <mailto:notmuch@notmuchmail.org>
\r
61 List-Help: <mailto:notmuch-request@notmuchmail.org?subject=help>
\r
62 List-Subscribe: <http://notmuchmail.org/mailman/listinfo/notmuch>,
\r
63 <mailto:notmuch-request@notmuchmail.org?subject=subscribe>
\r
64 X-List-Received-Date: Sun, 06 Nov 2011 21:41:51 -0000
\r
68 On Sun, 6 Nov 2011 12:17:36 -0500, Austin Clements <amdragon@MIT.EDU> wrote:
\r
69 > Search retrieves these headers for every message in the search
\r
70 > results. Previously, this required opening and parsing every message
\r
71 > file. Storing them directly in the database significantly reduces IO
\r
72 > and computation, speeding up search by between 50% and 10X.
\r
74 Just tried the patch and I can confirm that, after rebuilding the
\r
75 database, it makes searches a lot faster.
\r
81 Content-Type: application/pgp-signature
\r
83 -----BEGIN PGP SIGNATURE-----
\r
84 Version: GnuPG v1.4.11 (GNU/Linux)
\r
86 iQIcBAEBAgAGBQJOtv8MAAoJEIaTAtce+Z+J6RwP/07Y9mTBQS8KONzOwXKjKoI3
\r
87 6r6lQFVDB/euSDTQUkT3XGhlJwL7MtrGDLJjeAnx7+O7r2TGE4lSoJVrHAZu39lp
\r
88 nuDZdW6au9PRJf605EY0q2rmoIpchbG98vNaaASZXEzTDC+XWMBTooBEQxGdOykX
\r
89 /kzXpwHRKDhxDN+8wcNtVfRmHk9tXCsOLcvrA8wBQvWT7g0OA6/xOOpbqpEVCIpj
\r
90 pTQwyGmw2vmGnd8SvhDzn2SAabBf0LjmLmZGJF8hYSyUt0+CaC2I+1Pst55xM14E
\r
91 SMFVdmWJRjjwJUKOhMZ2hl6eWVr3//iqjv7K3btpZWJLpZQievJOU7pgpTmc0vZe
\r
92 6etmysSX227cYzeCMBtmgRiufZjUzjbO1UgsJ8X19Xjn1mxlW7vR/O6YkizUfniC
\r
93 YfDY8Ikm/uIgfl8ZjIAbnbUeDH6vpoa17TLEg/T5XKtE1+UrfG+1oA8AGF+6L9Se
\r
94 Hz0OGftNFjL6NMPbiKgH22DJCJkAIUFg97AXrZ7EBWIjXgb+ikVURZ+4CgTqkSBf
\r
95 +Jbnp8jLD4koJfhRWw7F7xKf+NPDz4EMKJgLicNuGHG9v2KZf+lv/vh9kUKWW8qn
\r
96 GJB1rnTq6QRwvROoZZSvmRahLxizZ2DUpvrBVPgtj7T56xBM1k1Gcu/ufV0veXtT
\r
97 RG1CA/PDmLvgn6c5msmb
\r
99 -----END PGP SIGNATURE-----
\r