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 776DB429E26 for ; Mon, 14 Nov 2011 17:13:00 -0800 (PST) X-Virus-Scanned: Debian amavisd-new at olra.theworths.org X-Spam-Flag: NO X-Spam-Score: -0.7 X-Spam-Level: X-Spam-Status: No, score=-0.7 tagged_above=-999 required=5 tests=[RCVD_IN_DNSWL_LOW=-0.7] 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 DX86i4hazTbS for ; Mon, 14 Nov 2011 17:13:00 -0800 (PST) Received: from dmz-mailsec-scanner-5.mit.edu (DMZ-MAILSEC-SCANNER-5.MIT.EDU [18.7.68.34]) by olra.theworths.org (Postfix) with ESMTP id EE223431FB6 for ; Mon, 14 Nov 2011 17:12:59 -0800 (PST) X-AuditID: 12074422-b7ff56d00000092f-77-4ec1bc99f261 Received: from mailhub-auth-4.mit.edu ( [18.7.62.39]) by dmz-mailsec-scanner-5.mit.edu (Symantec Messaging Gateway) with SMTP id 54.92.02351.99CB1CE4; Mon, 14 Nov 2011 20:12:57 -0500 (EST) Received: from outgoing.mit.edu (OUTGOING-AUTH.MIT.EDU [18.7.22.103]) by mailhub-auth-4.mit.edu (8.13.8/8.9.2) with ESMTP id pAF1CuUq016478; Mon, 14 Nov 2011 20:12:56 -0500 Received: from awakening.csail.mit.edu (awakening.csail.mit.edu [18.26.4.91]) (authenticated bits=0) (User authenticated as amdragon@ATHENA.MIT.EDU) by outgoing.mit.edu (8.13.6/8.12.4) with ESMTP id pAF1CtGZ017167 (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NOT); Mon, 14 Nov 2011 20:12:56 -0500 (EST) Received: from amthrax by awakening.csail.mit.edu with local (Exim 4.77) (envelope-from ) id 1RQ7cf-0001ou-4Y; Mon, 14 Nov 2011 20:15:37 -0500 From: Austin Clements To: notmuch@notmuchmail.org Subject: [PATCH] news: Store "from" and "subject" headers in the database. Date: Mon, 14 Nov 2011 20:15:33 -0500 Message-Id: <1321319734-6952-1-git-send-email-amdragon@mit.edu> X-Mailer: git-send-email 1.7.7.1 In-Reply-To: <87ty66b8bq.fsf@zancas.localnet> References: <87ty66b8bq.fsf@zancas.localnet> X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFtrEIsWRmVeSWpSXmKPExsUixG6nrjtzz0E/g20bFSyu35zJ7MDo8WzV LeYAxigum5TUnMyy1CJ9uwSujJdvd7IVvGarWLVuBmsD4zrWLkZODgkBE4lDF3uYIWwxiQv3 1rN1MXJxCAnsY5RovT6TBcLZwCjRfvEEM4RzkkliRfcXRghnM6PEi45mdpB+NgENiW37lzOC 2CIC0hI7784G2sHBwSygJvGnSwUkLCzgJTG/fzoTiM0ioCox88dhsDN4Bewljrb2sIGUSwgo SCzbUQ0S5hTQlZizZzLYdUICOhJXjsxhmsDIv4CRYRWjbEpulW5uYmZOcWqybnFyYl5eapGu qV5uZoleakrpJkZw0Lgo7WD8eVDpEKMAB6MSD+/JkIN+QqyJZcWVuYcYJTmYlER5O3cDhfiS 8lMqMxKLM+KLSnNSiw8xSnAwK4nwBpUB5XhTEiurUovyYVLSHCxK4rxcOx38hATSE0tSs1NT C1KLYLIyHBxKErzHQYYKFqWmp1akZeaUIKSZODhBhvMADd8FUsNbXJCYW5yZDpE/xagoJc7b CpIQAElklObB9cKi+hWjONArwhAreIAJAa77FdBgJqDBaw8eABlckoiQkmpg1P5S1SGy6MXd lm3CbVW2ne9nHRKfJrviLOe7etfcObMXzF8UrfhHo9iN7embKg6ZuUrRmzkMeb3O3d+SveDd fv9rzVEKbX1WCjtD706dzJP5o2FmYficqlie36urHdYwLOn7eI1R1XXxidc3fkQFr3738TNn +CqBD2951mUHZTgYVb3yKtuoqcRSnJFoqMVcVJwIAAbQSRjFAgAA 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: Tue, 15 Nov 2011 01:13:00 -0000 --- NEWS | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/NEWS b/NEWS index 71c7c9a..88f7b20 100644 --- a/NEWS +++ b/NEWS @@ -23,6 +23,21 @@ Add search terms to "notmuch dump" search/show/tag. The output file argument of dump is deprecated in favour of using stdout. +Optimizations +------------- + +Search avoids opening and parsing message files + + We now store more information in the database so search no longer + has to open every message file to get basic headers. This can + improve search speed by as much as 10X, but taking advantage of this + requires a database rebuild: + + notmuch dump > notmuch.dump + # Backup, then remove notmuch database ($MAIL/.notmuch) + notmuch new + notmuch restore notmuch.dump + Notmuch 0.9 (2011-10-01) ======================== -- 1.7.7.1