At 11:09 10/07/2002 +0200, Roel Rozendaal wrote:
what exactly do you mean by 'mailbox rebuild'? The imap search command
is not yet optimized and does work quite inefficiently for the time
being.
That is what Eudora 5.1 calls it; basically it brings a local copy of a
mailbox in sync with the server version. The same O(N^2) stuff happens
(with Eudora) when a new message is received as well. Judging by your
comments, it sounds like this is a problem with Eudora? If so, how do other
mail clients make sure that mailboxes are in sync (ISTM that using message
ID would be pretty sensible, which Eudora does not seem to do)?
regards roel
On Wed, 2002-07-10 at 06:28, Philip Warner wrote:
>
> Not sure if this is limited to my installation or not, but I would be
> interested to know if anyone else sees this (eg. with mySQL). When I
> 'rebuild' an IMAP mailbox, the entire mailbox is scanned for each mail
> message in the client mailbox. If the two mailboxes are actually in sync,
> this results on O(N^2) queries being executed. This also seems to happen
> when new mail arrives.
>
> The messages I see are:
>
> SELECT messageblk FROM messageblks WHERE message_idnr =
> <some-value>::bigint ORDER BY messageblk_idnr
>
> It seems like it's retrieving entire message bodies just to rebuild the
> mailbox. The IMAP commands that are sent look like:
>
> COMMAND: [00039 UID SEARCH UID 52263 OR (HEADER To
> [EMAIL PROTECTED]) (HEADER Cc
[EMAIL PROTECTED])]
>
> This question was part of an earlier posting, but was not addressed in any
> of the replies.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
