I think this question is nearly identical to the one I sent a few days ago, but just in case not:
We have someone running a search like this:
select count(DOCID) indexcnt from tbldoc where (tbldoc.ADDRESSEE LIKE '"water/testing"')
We're using double-quotes to indicate an exact phrase search, and while the search does return hits eventually, it takes a good while. Much longer than searching for "water" or "testing" alone. I figure Texis must be doing a linear search? Just for yuks I put a backslash in the term "water\/testing", but that led to zero hits returned.
Below is the index on the field in question. Thanks again, guys:
tsql "set keepnoise='on';set delexp=0;set addexp='\alnum{1,99}';set addexp='>>\a
lpha{1,50},=\alpha{1,50}';create metamorph inverted index idxmtbldoc_ADDRESSEE on tbldoc(ADDRESSEE);"
We have someone running a search like this:
select count(DOCID) indexcnt from tbldoc where (tbldoc.ADDRESSEE LIKE '"water/testing"')
We're using double-quotes to indicate an exact phrase search, and while the search does return hits eventually, it takes a good while. Much longer than searching for "water" or "testing" alone. I figure Texis must be doing a linear search? Just for yuks I put a backslash in the term "water\/testing", but that led to zero hits returned.
Below is the index on the field in question. Thanks again, guys:
tsql "set keepnoise='on';set delexp=0;set addexp='\alnum{1,99}';set addexp='>>\a
lpha{1,50},=\alpha{1,50}';create metamorph inverted index idxmtbldoc_ADDRESSEE on tbldoc(ADDRESSEE);"
