Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The exact phrase needs to be found
Message
From
18/12/2010 02:46:29
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Level Extreme
Category:
Other
Miscellaneous
Thread ID:
01385793
Message ID:
01493197
Views:
58
>>I found a switch at the table level, where there seems to be additional properties not available under the Storage tree. There is a switch to use or not the stoplist. When disabled, the index becomes bloated. So, we cannot use that. I will see about allowing specific words, which means, moving them out of the stoplist table. But, for now, I would suggest, when going for an exact match, to avoid the "the" in front and use the rest such as "report writer".
>>
>>Because, basically, using "the report writer" and "report writer", as search criteria, returns the same amount of records because the word "the" is omitted from the search.
>
>In other words, use both criteria - the index and LIKE (as I also suggested originally).
>
>The index will be quick and then if you're looking for exact phrase, you filter the results with LIKE.

I once did that on dbfs, indexing for most of the words (omitted a few - articles, short lowercase words etc), on a fpt of about 190 megs, and the size of the index table was 59M dbf + 64M cdx, and it would give the result set blazingly fast. Then searching for exact phrase in the result set, using simple atc() on the phrase was easy and just as fast.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform