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.
--
Remo Del Bello
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
To search the archives:
<http://www.mail-archive.com/entourage-talk%40lists.boingo.com/>
