8f/ba561c9f283ab547e05edbede896428fc3042e

   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
   8 X-Spam-Flag: NO\r
   9 X-Spam-Score: -0.79\r
  10 X-Spam-Level: \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
  35         [178.4.74.193])\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
  48 MIME-Version: 1.0\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
  54 Precedence: list\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
  65 \r
  66 --=-=-=\r
  67 \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
  73 \r
  74 Just tried the patch and I can confirm that, after rebuilding the\r
  75 database, it makes searches a lot faster.\r
  76 \r
  77 Cheers,\r
  78 Daniel\r
  79 \r
  80 --=-=-=\r
  81 Content-Type: application/pgp-signature\r
  82 \r
  83 -----BEGIN PGP SIGNATURE-----\r
  84 Version: GnuPG v1.4.11 (GNU/Linux)\r
  85 \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
  98 =uEeW\r
  99 -----END PGP SIGNATURE-----\r
 100 --=-=-=--\r