[thelist] Destroy and search

[Ken Schaefer]

No, it won't store the record "as is". That wouldn't be any faster to search
than storing the text verbatim.

Instead, something like a list of words would be created, and then linked to
appropriate objects. So the word "the" might be contained in records 1, 5, 52
and 529. Rather than searching through all the text in all the records for
the word "the", the DBMS would look up "the" in the index and know
immediately which records contained that word. It's a little more complex
than that, but you get the basic idea.

Cheers
Ken

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Chris Hayes
Sent: Friday, 28 October 2005 11:12 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Destroy and search

I guess that blows that plan out of the water.

Does it store all the text as-is or break it down into most common words,
phrases, etc.

Is there a way to achieve what I want?



----- Original Message ----- 
From: "Ken Schaefer" <Ken at adOpenStatic.com>
To: <thelist at lists.evolt.org>
Sent: Friday, October 28, 2005 11:14 AM
Subject: Re: [thelist] Destroy and search


> If you are "full text" indexing the data, then the index will contain all
the
> text that the data contains...
>
> Cheers
> Ken