Thunderstone Support Forums

Hi,

I am trying to speed up the searching against one of my vortex tables by using either a "like" or a "likep" instead of a "=" expression.

I am searching against the ID column with is type counter and I have created a metamorph inverted index on that column. When I do a search I am getting:

"100 Can't rank FTN type 19 in the function i3dbinsertp"

Here are some more details
<sql "set hyphenphrase = 0"></sql>
<sql "set addexp='[\alnum\/\+\-\._/]{1,70}'"></sql>

What am I doing wrong here?

Thanks. I hate opening up a trouble ticket on this. Have a great day John.

No one's explicitly said it so I will just to cover the bases. Creating a regular index on the counter field will make the = lookup fast.

Thanks

boy did that do the trick. Thanks Mark