From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by olra.theworths.org (Postfix) with ESMTP id 59780429E21 for ; Sun, 6 Nov 2011 13:41:51 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at olra.theworths.org X-Spam-Flag: NO X-Spam-Score: -0.79 X-Spam-Level: X-Spam-Status: No, score=-0.79 tagged_above=-999 required=5 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_LOW=-0.7, T_MIME_NO_TEXT=0.01] 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 9biOxnv53Adm for ; Sun, 6 Nov 2011 13:41:50 -0800 (PST) Received: from mail-fx0-f53.google.com (mail-fx0-f53.google.com [209.85.161.53]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by olra.theworths.org (Postfix) with ESMTPS id 553A4431FB6 for ; Sun, 6 Nov 2011 13:41:50 -0800 (PST) Received: by faan15 with SMTP id n15so1758595faa.26 for ; Sun, 06 Nov 2011 13:41:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=schoepe.org; s=google; h=from:to:cc:subject:in-reply-to:references:user-agent:date :message-id:mime-version:content-type; bh=hF6kYFAJ0ZtBgR8fJ+016ho8z2/q9ZMIs596A7TghRY=; b=be4Mvyj8XL0lqxmGKFpKWxW0qViuXLmKYC6SJUQhTjnaSKEF4J42mhd7P/6p4IbVij 6hkiFmdCO6jxPBSDlyxtMS7PKjnCHSJGVBeBvI+AV0Igv/gzYCewpVaUmoAzTO93CCBi ZkG16jYVdWtZQTvLojHfiMkZvNDabf9ZKbEvc= Received: by 10.223.7.20 with SMTP id b20mr41991959fab.21.1320615708894; Sun, 06 Nov 2011 13:41:48 -0800 (PST) Received: from localhost (dslb-178-004-074-193.pools.arcor-ip.net. [178.4.74.193]) by mx.google.com with ESMTPS id y2sm28478556fag.12.2011.11.06.13.41.45 (version=TLSv1/SSLv3 cipher=OTHER); Sun, 06 Nov 2011 13:41:47 -0800 (PST) From: Daniel Schoepe To: Austin Clements , notmuch@notmuchmail.org Subject: Re: [PATCH] Store "from" and "subject" headers in the database. In-Reply-To: <1320599856-24078-1-git-send-email-amdragon@mit.edu> References: <1320599856-24078-1-git-send-email-amdragon@mit.edu> User-Agent: Notmuch/0.9+96~g2c80672 (http://notmuchmail.org) Emacs/23.3.1 (x86_64-pc-linux-gnu) Date: Sun, 06 Nov 2011 22:41:32 +0100 Message-ID: <87d3d5kjxv.fsf@gilead.invalid> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha1; protocol="application/pgp-signature" Cc: notmuch@kismala.com 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: Sun, 06 Nov 2011 21:41:51 -0000 --=-=-= On Sun, 6 Nov 2011 12:17:36 -0500, Austin Clements wrote: > Search retrieves these headers for every message in the search > results. Previously, this required opening and parsing every message > file. Storing them directly in the database significantly reduces IO > and computation, speeding up search by between 50% and 10X. Just tried the patch and I can confirm that, after rebuilding the database, it makes searches a lot faster. Cheers, Daniel --=-=-= Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iQIcBAEBAgAGBQJOtv8MAAoJEIaTAtce+Z+J6RwP/07Y9mTBQS8KONzOwXKjKoI3 6r6lQFVDB/euSDTQUkT3XGhlJwL7MtrGDLJjeAnx7+O7r2TGE4lSoJVrHAZu39lp nuDZdW6au9PRJf605EY0q2rmoIpchbG98vNaaASZXEzTDC+XWMBTooBEQxGdOykX /kzXpwHRKDhxDN+8wcNtVfRmHk9tXCsOLcvrA8wBQvWT7g0OA6/xOOpbqpEVCIpj pTQwyGmw2vmGnd8SvhDzn2SAabBf0LjmLmZGJF8hYSyUt0+CaC2I+1Pst55xM14E SMFVdmWJRjjwJUKOhMZ2hl6eWVr3//iqjv7K3btpZWJLpZQievJOU7pgpTmc0vZe 6etmysSX227cYzeCMBtmgRiufZjUzjbO1UgsJ8X19Xjn1mxlW7vR/O6YkizUfniC YfDY8Ikm/uIgfl8ZjIAbnbUeDH6vpoa17TLEg/T5XKtE1+UrfG+1oA8AGF+6L9Se Hz0OGftNFjL6NMPbiKgH22DJCJkAIUFg97AXrZ7EBWIjXgb+ikVURZ+4CgTqkSBf +Jbnp8jLD4koJfhRWw7F7xKf+NPDz4EMKJgLicNuGHG9v2KZf+lv/vh9kUKWW8qn GJB1rnTq6QRwvROoZZSvmRahLxizZ2DUpvrBVPgtj7T56xBM1k1Gcu/ufV0veXtT RG1CA/PDmLvgn6c5msmb =uEeW -----END PGP SIGNATURE----- --=-=-=--