On 11/16/2000 9:10 AM, "Remo Del Bello" <[EMAIL PROTECTED]> wrote:
> on 11/10/2000 9:13 PM, I scrawled:
>
>> Advanced Find in Entourage = ~37.09 seconds
>> Subsequent tries with Advanced Find = ~3.43 seconds
>> Entourage Window Filter = instantaneous (I was, frankly, amazed
>> at
>> this one!)
>> BBEdit Multi-file Search = ~12.28 seconds
>
> on 11/11/2000 12:01 AM, Barry Wainwright deftly typed out:
>
>> Must have an index on the from field. When is this generated? Is it
>> as messages arrive (in which case why isn't this index checked when
>> an advanced search is carried out?) or is it when the mail folder is
>> opened? In which case, is there a speed hit when opening large
>> mailboxes?
>
> on 11/13/2000 11:50 AM, Dan Crevier deftly typed out:
>
>> As you might guess, the message text field is *not* indexed in Entourage.
>> It's something we have considered. Do a lot of people often do searches of
>> the message text across all messages in the database?
>
> on 11/15/2000 8:43 PM, Michael W. Wellman deftly typed out:
>
>> In short, there's not a single entity into which you can encode and search.
>> Which is why you really need to index to do it right. (1)
>
> Sorry for almost summarizing the thread, but I wanted to quote all the
> pertinent postings to comment on them.
>
> I just realized something that bothers me... In my informal testing, whose
> results I quoted above, I was searching the "From" field. Throughout this
> discussion I had assumed that the "From" field was indexed, hence the
> fantastically fast results of the window filter. I had thought that Dan had
> said this, but could not come up with a message from him that would have
> given me this thought. I finally tracked the creation of that impression to
> a post by Barry, which, since it made perfect sense, I just accepted.
>
> But I just realized that the same field was searched using Advanced Find.
> The results of the Advanced Find and the window filter are wildly different.
> Why the discrepancy? Is the "From" field indexed? If it is, does Advanced
> Find not use the index as efficiently as the window filter does? Would we
> experience the same searching speed on an indexed "Message Body" that I
> experienced on a presumably indexed "From" field?
>
> I don't think the time savings would be worth the increase in the size of
> the database if that were the case.
No, the From field is not indexed either.
Dan
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
To search the archives:
<http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
