Wild char

[gaurav.shetti]

Small clarification.

Recently one of our users compained that using adm* returns 8 results and using admin* returns 32 results.

As i understand, it should return 8 or less than 8 results. Is there any limit to the number of characters that can be extended or appended to the query term while searching with *. Perhaps a setting in Thunderstone.

[John]

Checking vortex.log should give a clue if one of the limits was reached. The most likely one causing a problem is qmaxsetwords or qmaxwords, which control how many terms in the index are expanded from the wildcard. It may also be a sign of a poor index expression. You can do the following to see the full list of terms starting with adm:

set indexaccess=1;
select * from IndexName where Word matches 'adm%';

[gaurav.shetti]

I could see this used in some if conditions
<apicp qminwordlen 1>

<apicp suffixproc 0> or <apicp suffixproc 1>

<apicp minwordlen 4>


Will this affect the * (wild cards) things.

[John]

Those settings shouldn't affect the wildcard queries you have above.

[gaurav.shetti]

Is there any way, i can check what is the value set for qmaxsetwords or qmaxwords in texis.
Can you provide me the query for it ?

[John]

You can see the default values in the docs at http://www.thunderstone.com/site/vortex ... ction.html

You can't query the current setting.

[gaurav.shetti]

Ok another question.. when i type adm* will it expand only english letters. like if i have some word like administración .. notice that 'o', will it be searched by that query adm*.

[John]

It should match based on your settings for index expression and word characters. In any case it should match, the question would be how much of the word is considered to be the match (administración or administraci).