Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The exact phrase needs to be found
Message
 
 
À
17/12/2010 14:53:08
Information générale
Forum:
Level Extreme
Catégorie:
Autre
Divers
Thread ID:
01385793
Message ID:
01493152
Vues:
62
>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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform