[PATCH] Store "from" and "subject" headers in the database.

Jameson Graef Rollins jrollins at finestructure.net
Sun Nov 13 22:34:38 PST 2011


On Sun,  6 Nov 2011 12:17:36 -0500, Austin Clements <amdragon at MIT.EDU> wrote:
> This is a rebase and cleanup of Istvan Marko's patch from
> id:m3pqnj2j7a.fsf at zsu.kismala.com
> 
> 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.

Hey, Austin.  This is a very nice patch.  Short and sweet, a really nice
performance improvement, and a nice gentle fallback.

I just rebuilt my database and I can definitely see the improvements.
Search results are incredibly snappy, and the resultant database is only
about 8% bigger.

I fully endorse this being pushed.

jamie.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 835 bytes
Desc: not available
URL: <http://notmuchmail.org/pipermail/notmuch/attachments/20111113/fe58b8d2/attachment-0001.pgp>


More information about the notmuch mailing list