Hi, I tried the FTS (and FTS Squat) plugin today, and it works as advertised. But: On my 13000 folders with 160000 mails maildir I use for testing, the speed increase is not as big as one would wish (it still takes several minutes to complete a search). Is my assumption correct, that there is no way to do a search over a big IMAP folder hierarchy in a reasonable amount of time, because each folder has to be 'selected', and only one folder can be selected at once? Patrick. -- STAR Software (Shanghai) Co., Ltd. http://www.star-group.net/ Phone: +86 (21) 3462 7688 x 826 Fax: +86 (21) 3462 7779 PGP key: https://stshacom1.star-china.net/keys/patrick_nagel.asc Fingerprint: E09A D65E 855F B334 E5C3 5386 EF23 20FC E883 A005 -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part. URL: <http://dovecot.org/pipermail/dovecot/attachments/20080624/ac95982f/attachment-0002.bin>
Patrick Nagel
2008-Jun-24 07:29 UTC
[Dovecot] Search over big folder hierarchy (was: Global FTS index?)
On Tuesday 24 June 2008, Patrick Nagel wrote:> Hi, > > I tried the FTS (and FTS Squat) plugin today, and it works as advertised. > > But: On my 13000 folders with 160000 mails maildir I use for testing, the > speed increase is not as big as one would wish (it still takes several > minutes to complete a search). > > Is my assumption correct, that there is no way to do a search over a big > IMAP folder hierarchy in a reasonable amount of time, because each folder > has to be 'selected', and only one folder can be selected at once? > > Patrick.I think this subject is more suitable for the mail's content. At first I focussed on the FTS index, and changed the mail later on, after which I forgot to change the subject... Patrick. -- STAR Software (Shanghai) Co., Ltd. http://www.star-group.net/ Phone: +86 (21) 3462 7688 x 826 Fax: +86 (21) 3462 7779 PGP key: https://stshacom1.star-china.net/keys/patrick_nagel.asc Fingerprint: E09A D65E 855F B334 E5C3 5386 EF23 20FC E883 A005 -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part. URL: <http://dovecot.org/pipermail/dovecot/attachments/20080624/b5d4f9a6/attachment-0002.bin>
> Is my assumption correct, that there is no way to do a search over a big IMAP > folder hierarchy in a reasonable amount of time, because each folder has to > be 'selected', and only one folder can be selected at once?This isn't 100% what you're looking for, but.. consider looking at "mairix". It does do full text search of mbox and maildir; it is a cli. Give it a search, and it populates a mail folder (using hardlinks if possible) with the results. I use it when I want to search my archives; the speed makes up for it not being native to the imap client. http://www.rc0.org.uk/mairix/